johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,226 rows where confirmed = 254 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1366282 | 1366282 | 2022-10-28 | China | Qinghai | 254 | 0 | 0 | 35.7452 | 95.9956 | 2022-10-29 04:21:13 | Qinghai, China | |||
3038137 | 3038137 | 2022-10-27 | China | Qinghai | 254 | 0 | 0 | 35.7452 | 95.9956 | 2022-10-28 04:22:31 | Qinghai, China | |||
2404080 | 2404080 | 2022-08-21 | US | Iowa | Unassigned | 90019 | 254 | 0 | 0 | 43.38107862 | 0.0 | 2022-08-22 04:20:38 | Unassigned, Iowa, US | |
3799158 | 3799158 | 2022-08-20 | US | Iowa | Unassigned | 90019 | 254 | 0 | 0 | 43.38107862 | 0.0 | 2022-08-21 04:20:44 | Unassigned, Iowa, US | |
2364744 | 2364744 | 2022-08-19 | US | Iowa | Unassigned | 90019 | 254 | 0 | 0 | 43.38107862 | 0.0 | 2022-08-20 04:21:01 | Unassigned, Iowa, US | |
1162415 | 1162415 | 2022-08-18 | US | Iowa | Unassigned | 90019 | 254 | 0 | 0 | 43.38107862 | 0.0 | 2022-08-19 04:20:54 | Unassigned, Iowa, US | |
1088982 | 1088982 | 2022-08-09 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-10 04:20:57 | Sully, South Dakota, US | |
3546397 | 3546397 | 2022-08-08 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-09 04:20:34 | Sully, South Dakota, US | |
1072800 | 1072800 | 2022-08-07 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-08 04:21:08 | Sully, South Dakota, US | |
1943388 | 1943388 | 2022-08-06 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-07 04:20:54 | Sully, South Dakota, US | |
883187 | 883187 | 2022-08-05 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-06 04:20:56 | Sully, South Dakota, US | |
2011598 | 2011598 | 2022-08-04 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-05 04:20:52 | Sully, South Dakota, US | |
1101025 | 1101025 | 2022-08-03 | US | South Dakota | Sully | 46119 | 254 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-08-04 04:20:58 | Sully, South Dakota, US | |
632553 | 632553 | 2022-07-12 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-13 04:20:58 | Wheeler, Oregon, US | |
1214197 | 1214197 | 2022-07-11 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-12 04:20:51 | Wheeler, Oregon, US | |
2791679 | 2791679 | 2022-07-10 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-11 04:20:46 | Wheeler, Oregon, US | |
144632 | 144632 | 2022-07-09 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-10 04:20:54 | Wheeler, Oregon, US | |
1420315 | 1420315 | 2022-07-08 | US | Texas | Sterling | 48431 | 254 | 7 | 0 | 31.82781912 | -101.0500746 | 2022-07-09 04:20:59 | Sterling, Texas, US | |
1419732 | 1419732 | 2022-07-08 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-09 04:20:59 | Wheeler, Oregon, US | |
2744240 | 2744240 | 2022-07-07 | US | Texas | Sterling | 48431 | 254 | 7 | 0 | 31.82781912 | -101.0500746 | 2022-07-08 04:20:56 | Sterling, Texas, US | |
2744175 | 2744175 | 2022-07-07 | US | Texas | Loving | 48301 | 254 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-07-08 04:20:56 | Loving, Texas, US | |
2743657 | 2743657 | 2022-07-07 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-08 04:20:56 | Wheeler, Oregon, US | |
1202452 | 1202452 | 2022-07-06 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-07 04:20:55 | Wheeler, Oregon, US | |
3969195 | 3969195 | 2022-07-05 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-06 04:20:58 | Wheeler, Oregon, US | |
3080706 | 3080706 | 2022-07-04 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-05 04:20:45 | Wheeler, Oregon, US | |
1769988 | 1769988 | 2022-07-03 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-04 04:20:54 | Wheeler, Oregon, US | |
3367974 | 3367974 | 2022-07-02 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-03 04:20:59 | Wheeler, Oregon, US | |
596303 | 596303 | 2022-07-01 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-02 04:21:16 | Wheeler, Oregon, US | |
3942704 | 3942704 | 2022-06-30 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-07-01 04:21:10 | Wheeler, Oregon, US | |
2492662 | 2492662 | 2022-06-29 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-30 04:21:01 | Wheeler, Oregon, US | |
2242044 | 2242044 | 2022-06-28 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-29 04:20:59 | Wheeler, Oregon, US | |
2150286 | 2150286 | 2022-06-27 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-28 04:20:58 | Wheeler, Oregon, US | |
478087 | 478087 | 2022-06-26 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-27 04:21:00 | Wheeler, Oregon, US | |
941462 | 941462 | 2022-06-25 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-26 04:21:02 | Wheeler, Oregon, US | |
3349282 | 3349282 | 2022-06-24 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-25 04:20:57 | Wheeler, Oregon, US | |
1651023 | 1651023 | 2022-06-23 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-24 04:20:58 | Wheeler, Oregon, US | |
2190258 | 2190258 | 2022-06-22 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-23 04:20:55 | Wheeler, Oregon, US | |
168689 | 168689 | 2022-06-21 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-22 04:20:54 | Wheeler, Oregon, US | |
1765972 | 1765972 | 2022-06-20 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-21 04:20:56 | Wheeler, Oregon, US | |
3272158 | 3272158 | 2022-06-19 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-20 04:21:01 | Wheeler, Oregon, US | |
3400070 | 3400070 | 2022-06-18 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-19 04:20:51 | Wheeler, Oregon, US | |
2313947 | 2313947 | 2022-06-17 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-18 04:21:10 | Wheeler, Oregon, US | |
2311942 | 2311942 | 2022-06-17 | US | Colorado | Mineral | 8079 | 254 | 2 | 0 | 37.66954283 | -106.9281698 | 2022-06-18 04:21:10 | Mineral, Colorado, US | |
561451 | 561451 | 2022-06-16 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-17 04:20:56 | Wheeler, Oregon, US | |
559446 | 559446 | 2022-06-16 | US | Colorado | Mineral | 8079 | 254 | 2 | 0 | 37.66954283 | -106.9281698 | 2022-06-17 04:20:56 | Mineral, Colorado, US | |
3985253 | 3985253 | 2022-06-15 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-16 04:20:55 | Wheeler, Oregon, US | |
949494 | 949494 | 2022-06-14 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-15 04:20:54 | Wheeler, Oregon, US | |
2981902 | 2981902 | 2022-06-13 | US | Oregon | Wheeler | 41069 | 254 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-06-14 04:20:52 | Wheeler, Oregon, US | |
3159627 | 3159627 | 2022-06-09 | US | Montana | Carter | 30011 | 254 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-06-10 04:20:55 | Carter, Montana, US | |
1423094 | 1423094 | 2022-06-08 | US | Montana | Carter | 30011 | 254 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-06-09 04:20:54 | Carter, Montana, US | |
3728208 | 3728208 | 2022-06-07 | US | Montana | Carter | 30011 | 254 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-06-08 04:20:55 | Carter, Montana, US | |
2447113 | 2447113 | 2022-02-22 | Tonga | 254 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-23 04:21:09 | Tonga | ||||
74325 | 74325 | 2022-02-07 | US | Texas | Throckmorton | 48447 | 254 | 7 | 0 | 33.17751417 | -99.21226795 | 2022-02-08 04:21:15 | Throckmorton, Texas, US | |
2015941 | 2015941 | 2022-02-06 | US | Texas | Throckmorton | 48447 | 254 | 7 | 0 | 33.17751417 | -99.21226795 | 2022-02-07 04:21:05 | Throckmorton, Texas, US | |
1297270 | 1297270 | 2022-02-05 | US | Texas | Throckmorton | 48447 | 254 | 7 | 0 | 33.17751417 | -99.21226795 | 2022-02-06 04:21:00 | Throckmorton, Texas, US | |
2330598 | 2330598 | 2022-02-04 | US | Texas | Throckmorton | 48447 | 254 | 7 | 0 | 33.17751417 | -99.21226795 | 2022-02-05 04:21:05 | Throckmorton, Texas, US | |
1230040 | 1230040 | 2022-01-24 | US | North Dakota | Sheridan | 38083 | 254 | 6 | 0 | 47.57700669 | -100.3426391 | 2022-01-25 04:21:05 | Sheridan, North Dakota, US | |
1143339 | 1143339 | 2022-01-23 | US | North Dakota | Sheridan | 38083 | 254 | 6 | 0 | 47.57700669 | -100.3426391 | 2022-01-24 04:21:12 | Sheridan, North Dakota, US | |
3467057 | 3467057 | 2022-01-18 | US | South Dakota | Hyde | 46069 | 254 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-19 04:21:23 | Hyde, South Dakota, US | |
1474996 | 1474996 | 2022-01-17 | US | South Dakota | Hyde | 46069 | 254 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-18 04:21:04 | Hyde, South Dakota, US | |
557670 | 557670 | 2022-01-16 | US | South Dakota | Hyde | 46069 | 254 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-17 04:21:08 | Hyde, South Dakota, US | |
3843391 | 3843391 | 2022-01-15 | US | South Dakota | Hyde | 46069 | 254 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-16 04:21:12 | Hyde, South Dakota, US | |
102206 | 102206 | 2022-01-14 | US | South Dakota | Hyde | 46069 | 254 | 5 | 0 | 44.54747703 | -99.48572582 | 2022-01-15 04:21:07 | Hyde, South Dakota, US | |
1116817 | 1116817 | 2022-01-11 | US | Texas | Stonewall | 48433 | 254 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2022-01-12 04:21:44 | Stonewall, Texas, US | |
129861 | 129861 | 2022-01-09 | US | Texas | Irion | 48235 | 254 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-10 04:22:07 | Irion, Texas, US | |
1392722 | 1392722 | 2022-01-07 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-08 04:21:53 | Cottle, Texas, US | |
2613404 | 2613404 | 2022-01-06 | US | Virginia | Highland | 51091 | 254 | 4 | 0 | 38.35799465 | -79.56124594 | 2022-01-07 04:22:09 | Highland, Virginia, US | |
2613109 | 2613109 | 2022-01-06 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-07 04:22:09 | Cottle, Texas, US | |
1285051 | 1285051 | 2022-01-05 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-06 04:22:09 | Cottle, Texas, US | |
1289067 | 1289067 | 2022-01-04 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-05 04:21:59 | Cottle, Texas, US | |
1703411 | 1703411 | 2022-01-03 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-04 04:22:17 | Cottle, Texas, US | |
1702627 | 1702627 | 2022-01-03 | US | New York | Unassigned | 90036 | 254 | 1 | 0 | 44.74530905 | 0.0 | 2022-01-04 04:22:17 | Unassigned, New York, US | |
3522494 | 3522494 | 2022-01-02 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-03 02:22:25 | Cottle, Texas, US | |
3521710 | 3521710 | 2022-01-02 | US | New York | Unassigned | 90036 | 254 | 1 | 0 | 44.74530905 | 0.0 | 2022-01-03 02:22:25 | Unassigned, New York, US | |
2170624 | 2170624 | 2022-01-01 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-02 04:20:52 | Cottle, Texas, US | |
2169840 | 2169840 | 2022-01-01 | US | New York | Unassigned | 90036 | 254 | 1 | 0 | 44.74530905 | 0.0 | 2022-01-02 04:20:52 | Unassigned, New York, US | |
2780055 | 2780055 | 2021-12-31 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-01-01 04:22:14 | Cottle, Texas, US | |
4001712 | 4001712 | 2021-12-30 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-31 04:21:50 | Cottle, Texas, US | |
1671519 | 1671519 | 2021-12-29 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-30 04:21:25 | Cottle, Texas, US | |
1669065 | 1669065 | 2021-12-29 | US | Colorado | Cheyenne | 8017 | 254 | 9 | 0 | 38.82777431 | -102.6032558 | 2021-12-30 04:21:25 | Cheyenne, Colorado, US | |
1435628 | 1435628 | 2021-12-28 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-29 03:21:43 | Cottle, Texas, US | |
1433174 | 1433174 | 2021-12-28 | US | Colorado | Cheyenne | 8017 | 254 | 9 | 0 | 38.82777431 | -102.6032558 | 2021-12-29 03:21:43 | Cheyenne, Colorado, US | |
733589 | 733589 | 2021-12-27 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-28 04:21:47 | Cottle, Texas, US | |
2114761 | 2114761 | 2021-12-26 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-27 04:21:58 | Cottle, Texas, US | |
3608133 | 3608133 | 2021-12-25 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-26 04:21:50 | Cottle, Texas, US | |
2966451 | 2966451 | 2021-12-24 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-25 04:21:37 | Cottle, Texas, US | |
3819483 | 3819483 | 2021-12-23 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-24 04:21:34 | Cottle, Texas, US | |
801491 | 801491 | 2021-12-22 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-23 04:21:21 | Cottle, Texas, US | |
3831531 | 3831531 | 2021-12-21 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-22 04:21:54 | Cottle, Texas, US | |
1257834 | 1257834 | 2021-12-20 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-21 03:21:27 | Cottle, Texas, US | |
1254457 | 1254457 | 2021-12-20 | Australia | Tasmania | 254 | 13 | 0 | -42.8821 | 147.3272 | 2021-12-21 03:21:27 | Tasmania, Australia | |||
2906777 | 2906777 | 2021-12-19 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-20 04:21:43 | Cottle, Texas, US | |
1261850 | 1261850 | 2021-12-18 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-19 04:21:11 | Cottle, Texas, US | |
2401878 | 2401878 | 2021-12-17 | US | Texas | Cottle | 48101 | 254 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-12-18 02:22:20 | Cottle, Texas, US | |
552849 | 552849 | 2021-12-08 | US | Nebraska | Garden | 31069 | 254 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-12-09 04:22:49 | Garden, Nebraska, US | |
406369 | 406369 | 2021-12-07 | US | Nebraska | Garden | 31069 | 254 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-12-08 04:22:46 | Garden, Nebraska, US | |
1233817 | 1233817 | 2021-11-28 | US | New Mexico | Catron | 35003 | 254 | 8 | 0 | 33.91514144 | -108.4046587 | 2021-11-29 04:22:30 | Catron, New Mexico, US | |
1233612 | 1233612 | 2021-11-28 | US | Missouri | Worth | 29227 | 254 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-29 04:22:30 | Worth, Missouri, US | |
1360524 | 1360524 | 2021-11-27 | US | New Mexico | Catron | 35003 | 254 | 8 | 0 | 33.91514144 | -108.4046587 | 2021-11-28 04:22:43 | Catron, New Mexico, US | |
1360319 | 1360319 | 2021-11-27 | US | Missouri | Worth | 29227 | 254 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-28 04:22:43 | Worth, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);