2c:null 2d:["$","title",null,{"children":"Internal: Mapping: Storage Provider to Country/State/Province [Provider.Quest] | Jim Pick | Observable"}] 32:T614,filteredAsks = { const entries = Object.entries(asksSubsetLatest.miners) .map(([miner, { timestamp, ...rest }]) => ([miner, { timestamp: d3.isoParse(timestamp), ...rest }])) .filter(([miner, ask]) => ( ask.timestamp >= minTimestamp && (filterOut.includes('ridiculous price') ? ask.priceDouble < 1e14 : true) && (filterOut.includes('ridiculous verified price') ? ask.verifiedPriceDouble < 1e14 : true) && (filterOut.includes('rejected') && legacyAnnotationsMainnet[miner] ? !legacyAnnotationsMainnet[miner].match(/^rejected,/) : true) && (filterOut.includes('no deals') ? (multidayDeals && multidayDeals[miner]): true) && (filterOut.includes('<5 deals') ? (multidayDeals && multidayDeals[miner] && multidayDeals[miner].count >= 5): true) && (filterOut.includes('<10 deals') ? (multidayDeals && multidayDeals[miner] && multidayDeals[miner].count >= 10): true) && (filterOut.includes('<50 deals') ? (multidayDeals && multidayDeals[miner] && multidayDeals[miner].count >= 50): true) && (filterOut.includes('<2 clients') ? (multidayDeals && multidayDeals[miner] && multidayDeals[miner]['approx_count_distinct(client)'] >= 2): true) && (filterOut.includes('<5 clients') ? (multidayDeals && multidayDeals[miner] && multidayDeals[miner]['approx_count_distinct(client)'] >= 5): true) /* && !legacyAnnotationsMainnet[miner].match(/^fail,/) && !legacyAnnotationsMainnet[miner].match(/^delist,/) */ )) .map(([miner, ask]) => ({miner, ...ask})) return entries }33:T520,minerIps = { const minerIps = new Map() for (const record of multiaddrsIpsReport.multiaddrsIps) { if (restrictResults === 'Only miners with recent asks') { if (!filteredAsks.find(({ miner }) => miner === record.miner)) continue } const maddrIps = minerIps.get(record.miner) || [] const maddrIpRecord = { maddr: record.maddr, ip: record.ip } if (record.chain) maddrIpRecord.chain = true if (record.dht) maddrIpRecord.dht = true if (latestIpsGeoLite2Report.ipsGeoLite2[record.ip]) { maddrIpRecord.geolite2 = latestIpsGeoLite2Report.ipsGeoLite2[record.ip] } if (latestIpsBaiduReport.ipsBaidu[record.ip]) { maddrIpRecord.baidu = latestIpsBaiduReport.ipsBaidu[record.ip] if (maddrIpRecord.baidu && maddrIpRecord.baidu.baidu && maddrIpRecord.baidu.baidu.address) { const match = maddrIpRecord.baidu.baidu.address.match(/^CN\|([^|]+)/) if (match && match[1] && chinaProvincesByCnName.get(match[1])) { maddrIpRecord.baidu.province = chinaProvincesByCnName.get(match[1]) } } } const region = regionMapper(maddrIpRecord.geolite2, maddrIpRecord.baidu) if (region) maddrIpRecord.region = region maddrIps.push(maddrIpRecord) minerIps.set(record.miner, maddrIps) } return minerIps }34:T51f,minerLocationsTable = { const minerLocationsTable = [] for (const miner of [...minerIps.keys()]) { const locations = new Map() const ipLocations = minerIps.get(miner) for (const ipLocation of ipLocations) { const { region, geolite2, baidu } = ipLocation if (!region) continue let { country, subdiv1, city, long, lat } = geolite2 ? geolite2 : {} if (baidu) { if (baidu.city) { subdiv1 = null city = baidu.city } if (baidu.long && baidu.lat) { long = baidu.long lat = baidu.lat } } if (!long || !lat) continue const key = `${region},` + `${country ? country : ''},` + `${subdiv1 ? subdiv1 : ''},` + `${city ? city : ''},` + `${long},${lat}` locations.set(key, { region, country, subdiv1, city, long, lat }) } for (const { region, country, subdiv1, city, long, lat } of locations.values()) { const locationRecord = { miner, region, long, lat, numLocations: locations.size } if (country) locationRecord.country = country if (subdiv1) locationRecord.subdiv1 = subdiv1 if (city) locationRecord.city = city minerLocationsTable.push(locationRecord) } } return minerLocationsTable.sort(sortMinerRecords) }35:[{"id":"a8affb1c22a7bd9298f69e03b29c11e28ce20625c02e3113f73c6a3def582a81f2cc38c2aabe71eca6bbb4abb796ad6f5db02af83a8da5f834dc0955b1418e8c","href":"https://static.observableusercontent.com/files/a8affb1c22a7bd9298f69e03b29c11e28ce20625c02e3113f73c6a3def582a81f2cc38c2aabe71eca6bbb4abb796ad6f5db02af83a8da5f834dc0955b1418e8c","name":"china-provinces.json","type":"application/json","lastModified":1641580854624.022,"size":1811}] 30:{"id":"e98f5037803ae3db","slug":"internal-mapping-storage-provider-to-countrystateprovin","title":"Internal: Mapping: Storage Provider to Country/State/Province [Provider.Quest]","thumbnail":"f6a6bf490c127f19ac9e277ec0f790fa9361ae9541616f048b706983067d5b64","access_level":"public","create_time":"$D2022-01-07T18:40:54.624Z","update_time":"$D2022-06-06T05:27:44.500Z","view_time":null,"first_public_time":"$D2022-01-07T18:56:15.625Z","fork":{"id":"c37e9322a32b8622","slug":"provider-quest-storage-provider-to-region-mapper","title":"Internal: Mapping: Storage Provider to Region [Provider.Quest]","owner":{"id":"5252cea433451319","login":"jimpick","name":"Jim Pick"}},"stars":1,"starred":false,"owner":{"type":"team","id":"5252cea433451319","login":"jimpick","name":"Jim Pick","avatar_url":"https://avatars-next.observableusercontent.com/e8813527082139d5411445010e72fd85f99b04a26355e795d0ea26765425d0cd","tier":"starter_2024"},"version":659,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"bda4505ba9a55ac8","login":"jimpick","name":"Jim Pick","avatar_url":"https://avatars-next.observableusercontent.com/e8813527082139d5411445010e72fd85f99b04a26355e795d0ea26765425d0cd","tier":null}],"members":[{"type":"individual","id":"bda4505ba9a55ac8","login":"jimpick","name":"Jim Pick","avatar_url":"https://avatars-next.observableusercontent.com/e8813527082139d5411445010e72fd85f99b04a26355e795d0ea26765425d0cd","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":{"id":"242749e359cb986b","slug":"provider-quest","title":"Provider.Quest","owner":{"id":"5252cea433451319","login":"jimpick","name":"Jim Pick"}},"type":"notebook","body":{"title":"Internal: Mapping: Storage Provider to Country/State/Province [Provider.Quest]","cells":[{"id":0,"value":"# Internal: Mapping: Storage Provider to Country/State/Province [Provider.Quest]","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"md`This notebook cross-references the list of storage providers with multiaddresses from the chain + DHT, and uses GeoIP lookup data to assign locations to each storage provider. Since storage providers may have multiple multiaddresses and IPs, and may be servicing requests from multiple regions, we assign weights to each region so aggregated statistics can be split.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"md`This hierarchy is similar to the \"regions\" hierarchy (see [@jimpick/provider-quest-storage-provider-to-region-mapper](https://observablehq.com/@jimpick/provider-quest-storage-provider-to-region-mapper?collection=@jimpick/provider-quest)), but with a slightly different organization where all countries are at the top level, except for the US and China, which are broken down by state/province.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"currentEpoch = dateToEpoch(new Date())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"import {multiaddrsIpsLatestBucketUrl} from '@jimpick/provider-quest-feeds'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":640,"value":"multiaddrsIpsLatestUrl = `${multiaddrsIpsLatestBucketUrl}/multiaddrs-ips-latest.json`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"multiaddrsIpsReport = (await fetch(multiaddrsIpsLatestUrl)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"import {geoIpLookupsBucketUrl} from '@jimpick/provider-quest-feeds'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":645,"value":"ipsGeoLite2LatestUrl = `${geoIpLookupsBucketUrl}/ips-geolite2-latest.json`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"latestIpsGeoLite2Report = (await fetch(ipsGeoLite2LatestUrl)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":653,"value":"ipsBaiduLatestUrl = `${geoIpLookupsBucketUrl}/ips-baidu-latest.json`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"latestIpsBaiduReport = (await fetch(ipsBaiduLatestUrl)).json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"chinaProvinces = FileAttachment(\"china-provinces.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"chinaProvincesByCnName = d3.index(chinaProvinces, d => d.cn)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":452,"value":"chinaProvincesByCode = d3.index(chinaProvinces, d => d.code)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"import {minerPowerDailyAverageLatestBucketUrl} from '@jimpick/miner-report-feeds'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":370,"value":"latestPowerReport = (await fetch(`${minerPowerDailyAverageLatestBucketUrl}/miner-power-latest.json`)).json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"import { asksSubsetLatest } from '@jimpick/provider-quest-feeds'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"minTimestamp = dateFns.subDays(new Date(), 3)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"import { legacyAnnotationsMainnet } from '@jimpick/provider-quest-feeds'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"import { dealsBucketUrl } from '@jimpick/provider-quest-feeds'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"multidayDealsReport = (await fetch(`${dealsBucketUrl}/multiday-average-latest.json`)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"multidayDeals = multidayDealsReport.providers","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"viewof restrictResults = Inputs.radio([\"All miners\", \"Only miners with recent asks\"], { label: 'Restrict results', value: 'All miners' })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"viewof filterOut = Inputs.checkbox([\"ridiculous price\", \"ridiculous verified price\", \"rejected\", \"no deals\", \"<5 deals\", \"<10 deals\", \"<50 deals\", \"<2 clients\", \"<5 clients\"], {label: \"Filter out asks\", value: [\"ridiculous price\", \"ridiculous verified price\", \"no deals\", \"<5 deals\", \"rejected\", \"<2 clients\"], disabled: restrictResults !== 'Only miners with recent asks' })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"regionHierarchy = ({\n name: 'root',\n children: [\n {\n name: 'Mainland China',\n code: 'CN',\n note: 'Does not include Hong Kong, Taiwan'\n },\n {\n name: 'USA',\n code: 'US'\n }\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"root = d3.hierarchy(_.cloneDeep(regionHierarchy))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"graph(root, {label: d => `${d.data.code ? d.data.code + ': ' : ''}${d.data.name}`})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":283,"value":"numberOfLeaves = root.copy().count().value","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"numberOfNodes = root.copy().sum(d => 1).value","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"indexedRoot = {\n function childrenIndex(d) {\n return d3.index(d.children.map(d => {\n const value = d.data\n if (value && value.children) {\n value.children = childrenIndex(d)\n }\n return value\n }), d => d.code)\n }\n return childrenIndex(root)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"function regionMapper (geolite2, baidu) {\n if (!geolite2) return null\n\n // Try to break into country-based subcategories if >10 miners\n const country = indexedRoot.get(geolite2.country)\n if (country) {\n if (country.code === 'CN') {\n if (baidu && baidu.province) {\n return `CN-${baidu.province.code}`\n }\n if (geolite2.subdiv1) {\n return `CN-${geolite2.subdiv1}`\n }\n return `CN-XX`\n }\n if (geolite2.subdiv1) {\n return `${country.code}-${geolite2.subdiv1}`\n }\n return `${country.code}-XX`\n } else {\n return geolite2.country\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"minerRegions = {\n const minerRegions = []\n for (const miner of [...minerIps.keys()]) {\n const regions = minerIps.get(miner).reduce(\n (regionSet, { region }) => region ? regionSet.add(region) : regionSet,\n new Set()\n )\n minerRegions.push({\n miner,\n regions: [...regions].sort()\n })\n }\n return minerRegions\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"md`## Zero-region miners`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"md`For some reason, the IP addresses for these miners didn't have any geolocation results.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"zeroRegionMinersList = minerRegions.filter(({ miner, regions }) => regions.length === 0).map(({ miner, regions }) => ({ miner, regions: regions.join(',') }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"zeroRegionMiners = zeroRegionMinersList.map(({ miner }) => miner).sort(sortMiners)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"md`## One-region miners`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"oneRegionMinersList = minerRegions.filter(({ miner, regions }) => regions.length === 1).map(({ miner, regions }) => ({ miner, region: regions[0] }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"regionCounts = Object.entries(oneRegionMinersList.reduce((regions, { miner, region }) => {\n regions[region] ||= 0\n regions[region]++\n return regions\n}, {})).map(([region, count]) => ({ region, count })).sort(({ count: a }, { count: b }) => b - a) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"viewof oneRegionSelected = Inputs.select(regionCounts, { format: ({ region, count }) => `${region} (${count} miners)` })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"selectedOneRegionMiners = oneRegionMinersList.filter(({ region }) => region === oneRegionSelected.region).map(({ miner }) => ({ miner, multiaddrIps: minerIps.get(miner) })).sort(sortMinerRecords)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"selectedOneRegionMinerCountries = selectedOneRegionMiners.reduce((countryCounts, minerRecord) => {\n for (const multiaddrIp of minerRecord.multiaddrIps) {\n if (multiaddrIp.geolite2) {\n const country = multiaddrIp.geolite2.country\n countryCounts[country] ||= new Set()\n countryCounts[country].add(minerRecord.miner)\n }\n }\n return countryCounts\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":579,"value":"Inputs.table(Object.entries(selectedOneRegionMinerCountries).map(([country, minerSet]) => ({ country, minerCount: minerSet.size, miners: [...minerSet].join(', ') })))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"countryPowerAndDeals = {\n const countryPowerAndDeals = {}\n for (const country in selectedOneRegionMinerCountries) {\n countryPowerAndDeals[country] ||= { qualityAdjPower: 0, dealsCount: 0, pieceSizeDouble: 0 }\n for (const miner of selectedOneRegionMinerCountries[country]) {\n if (latestPowerReport.miners[miner]) {\n countryPowerAndDeals[country].qualityAdjPower += latestPowerReport.miners[miner].qualityAdjPower\n }\n if (multidayDeals[miner]) {\n countryPowerAndDeals[country].dealsCount += multidayDeals[miner].count\n countryPowerAndDeals[country].pieceSizeDouble += multidayDeals[miner]['sum(pieceSizeDouble)']\n }\n }\n }\n return countryPowerAndDeals\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"countryPowerAndDealsBytes = Object.entries(countryPowerAndDeals).map(d => ({\n country: d[0],\n qualityAdjPower: d[1].qualityAdjPower,\n qualityAdjPowerBytes: bytes(d[1].qualityAdjPower, { mode: 'binary' }),\n dealsCount: d[1].dealsCount,\n pieceSizeDouble: bytes(d[1].pieceSizeDouble, { mode: 'binary' })\n})).sort((a, b) => b.qualityAdjPower - a.qualityAdjPower)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":581,"value":"Inputs.table(countryPowerAndDealsBytes)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"selectedOneRegionMinerStateProvinces = selectedOneRegionMiners.reduce((provinceCounts, minerRecord) => {\n for (const multiaddrIp of minerRecord.multiaddrIps) {\n if (multiaddrIp.baidu && multiaddrIp.baidu.province) {\n const province = multiaddrIp.baidu.province.code\n provinceCounts[province] ||= new Set()\n provinceCounts[province].add(minerRecord.miner)\n } else if (multiaddrIp.geolite2 && multiaddrIp.geolite2.subdiv1) {\n const province = multiaddrIp.geolite2.subdiv1\n provinceCounts[province] ||= new Set()\n provinceCounts[province].add(minerRecord.miner)\n }\n }\n return provinceCounts\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"Inputs.table(Object.entries(selectedOneRegionMinerStateProvinces).map(([stateProvince, minerSet]) => ({ stateProvince, minerCount: minerSet.size, miners: [...minerSet].join(', ') })))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"stateProvincePowerAndDeals = {\n const provincePowerAndDeals = {}\n for (const province in selectedOneRegionMinerStateProvinces) {\n provincePowerAndDeals[province] ||= { qualityAdjPower: 0, dealsCount: 0, pieceSizeDouble: 0 }\n for (const miner of selectedOneRegionMinerStateProvinces[province]) {\n if (latestPowerReport.miners[miner]) {\n provincePowerAndDeals[province].qualityAdjPower += latestPowerReport.miners[miner].qualityAdjPower\n }\n if (multidayDeals[miner]) {\n provincePowerAndDeals[province].dealsCount += multidayDeals[miner].count\n provincePowerAndDeals[province].pieceSizeDouble += multidayDeals[miner]['sum(pieceSizeDouble)']\n }\n }\n }\n return provincePowerAndDeals\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"stateProvincePowerAndDealsBytes = Object.entries(stateProvincePowerAndDeals).map(d => ({\n stateProvince: d[0],\n qualityAdjPower: d[1].qualityAdjPower,\n qualityAdjPowerBytes: bytes(d[1].qualityAdjPower, { mode: 'binary' }),\n dealsCount: d[1].dealsCount,\n pieceSizeDouble: bytes(d[1].pieceSizeDouble, { mode: 'binary' })\n})).sort((a, b) => b.qualityAdjPower - a.qualityAdjPower)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"Inputs.table(stateProvincePowerAndDealsBytes)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"md`## Multi-region miners`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"multiRegionMinersList = minerRegions.filter(({ miner, regions }) => regions.length > 1).map(({ miner, regions }) => ({ miner, regions: regions.join(',') }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"multiRegionCounts = Object.entries(multiRegionMinersList.reduce((multiRegions, { miner, regions }) => {\n multiRegions[regions] ||= 0\n multiRegions[regions]++\n return multiRegions\n}, {})).map(([regions, count]) => ({ regions, count })).sort(({ count: a }, { count: b }) => b - a) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"viewof multiRegionSelected = Inputs.select(multiRegionCounts, { format: ({ regions, count }) => `${regions} (${count} miners)` })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"selectedMultiRegionMiners = multiRegionMinersList.filter(({ regions }) => regions === multiRegionSelected.regions).map(({ miner }) => ({ miner, multiaddrIps: minerIps.get(miner) })).sort(sortMinerRecords)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"md`## Exported Maps`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"minerRegionsTable = {\n const minerRegionsTable = []\n for (const { miner, regions } of minerRegions) {\n for (const region of regions) {\n minerRegionsTable.push({\n miner,\n region,\n numRegions: regions.length\n })\n }\n }\n return minerRegionsTable.sort(sortMinerRecords)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"dateFns = require('https://bundle.run/date-fns@2.22.1')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"import {dateToEpoch, epochToDate} from '@jbenet/filecoin-chain-time-calculator'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"import {sortMiners, sortMinerRecords} from '@jimpick/provider-quest-utils'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"import {graph} from '@d3/d3-hierarchy'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"bytes = (await import('@jimpick/bytes-iec@3.1.0-2')).default","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"## Backups","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":627,"value":"import {backups, backupNowButton} from '@jimpick/provider-quest-utils'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"backups()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":657,"value":"backupNowButton()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 31:"$30:body"