johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
823 rows where confirmed = 346 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3253313 | 3253313 | 2022-10-11 | US | Texas | Loving | 48301 | 346 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-10-12 04:22:51 | Loving, Texas, US | |
2970572 | 2970572 | 2022-10-10 | US | Texas | Loving | 48301 | 346 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-10-11 04:23:05 | Loving, Texas, US | |
3952911 | 3952911 | 2022-08-17 | US | North Dakota | Oliver | 38065 | 346 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-08-18 04:21:11 | Oliver, North Dakota, US | |
993413 | 993413 | 2022-08-16 | US | North Dakota | Oliver | 38065 | 346 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-08-17 04:20:59 | Oliver, North Dakota, US | |
1071964 | 1071964 | 2022-08-07 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-08 04:21:08 | Dundy, Nebraska, US | |
1942552 | 1942552 | 2022-08-06 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-07 04:20:54 | Dundy, Nebraska, US | |
882351 | 882351 | 2022-08-05 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-06 04:20:56 | Dundy, Nebraska, US | |
2010762 | 2010762 | 2022-08-04 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-05 04:20:52 | Dundy, Nebraska, US | |
1100189 | 1100189 | 2022-08-03 | US | Nebraska | Dundy | 31057 | 346 | 6 | 0 | 40.17638677 | -101.6876522 | 2022-08-04 04:20:58 | Dundy, Nebraska, US | |
1406338 | 1406338 | 2022-08-02 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-08-03 04:20:59 | Greeley, Kansas, US | |
3618376 | 3618376 | 2022-08-01 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-08-02 04:20:53 | Greeley, Kansas, US | |
3872856 | 3872856 | 2022-07-31 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-08-01 04:21:03 | Greeley, Kansas, US | |
675610 | 675610 | 2022-07-30 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-31 04:21:02 | Greeley, Kansas, US | |
1784809 | 1784809 | 2022-07-29 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-30 04:20:42 | Greeley, Kansas, US | |
1067172 | 1067172 | 2022-07-28 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-29 04:20:45 | Greeley, Kansas, US | |
2336691 | 2336691 | 2022-07-27 | US | Kansas | Greeley | 20071 | 346 | 3 | 0 | 38.4808095 | -101.8061079 | 2022-07-28 04:20:56 | Greeley, Kansas, US | |
1200438 | 1200438 | 2022-07-06 | US | Colorado | Kiowa | 8061 | 346 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-07-07 04:20:55 | Kiowa, Colorado, US | |
3967181 | 3967181 | 2022-07-05 | US | Colorado | Kiowa | 8061 | 346 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-07-06 04:20:58 | Kiowa, Colorado, US | |
2264071 | 2264071 | 2022-03-14 | Peru | Unknown | 346 | 33 | 0 | 2022-03-15 04:20:47 | Unknown, Peru | |||||
3915247 | 3915247 | 2022-02-20 | US | Texas | Stonewall | 48433 | 346 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-21 04:21:05 | Stonewall, Texas, US | |
3878805 | 3878805 | 2022-02-19 | US | Texas | Stonewall | 48433 | 346 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-02-20 04:21:00 | Stonewall, Texas, US | |
461457 | 461457 | 2022-02-02 | US | Nebraska | Gosper | 31073 | 346 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-02-03 04:21:21 | Gosper, Nebraska, US | |
3062614 | 3062614 | 2022-01-29 | US | Colorado | Dolores | 8033 | 346 | 7 | 0 | 37.75208676 | -108.5211585 | 2022-01-30 04:21:26 | Dolores, Colorado, US | |
1143343 | 1143343 | 2022-01-23 | US | North Dakota | Steele | 38091 | 346 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-01-24 04:21:12 | Steele, North Dakota, US | |
3428077 | 3428077 | 2022-01-21 | US | Texas | Irion | 48235 | 346 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-22 04:21:13 | Irion, Texas, US | |
1964022 | 1964022 | 2022-01-20 | US | Washington | Wahkiakum | 53069 | 346 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-21 04:21:09 | Wahkiakum, Washington, US | |
3228500 | 3228500 | 2022-01-19 | US | Nebraska | Boyd | 31015 | 346 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2022-01-20 04:21:07 | Boyd, Nebraska, US | |
3616098 | 3616098 | 2022-01-12 | US | Texas | Briscoe | 48045 | 346 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-01-13 08:00:09 | Briscoe, Texas, US | |
3615947 | 3615947 | 2022-01-12 | US | South Dakota | Jerauld | 46073 | 346 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-01-13 08:00:09 | Jerauld, South Dakota, US | |
1115572 | 1115572 | 2022-01-11 | US | Missouri | Worth | 29227 | 346 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-01-12 04:21:44 | Worth, Missouri, US | |
1114490 | 1114490 | 2022-01-11 | US | Georgia | Webster | 13307 | 346 | 7 | 0 | 32.04066113 | -84.54742852 | 2022-01-12 04:21:44 | Webster, Georgia, US | |
1286782 | 1286782 | 2022-01-04 | US | Georgia | Clay | 13061 | 346 | 4 | 0 | 31.62221166 | -84.97713865 | 2022-01-05 04:21:59 | Clay, Georgia, US | |
3520792 | 3520792 | 2022-01-02 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2022-01-03 02:22:25 | Wallace, Kansas, US | |
2168922 | 2168922 | 2022-01-01 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2022-01-02 04:20:52 | Wallace, Kansas, US | |
2778353 | 2778353 | 2021-12-31 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2022-01-01 04:22:14 | Wallace, Kansas, US | |
4000010 | 4000010 | 2021-12-30 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2021-12-31 04:21:50 | Wallace, Kansas, US | |
1669817 | 1669817 | 2021-12-29 | US | Kansas | Wallace | 20199 | 346 | 5 | 0 | 38.91686134 | -101.76388759999999 | 2021-12-30 04:21:25 | Wallace, Kansas, US | |
1257947 | 1257947 | 2021-12-20 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-21 03:21:27 | Menard, Texas, US | |
2906890 | 2906890 | 2021-12-19 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-20 04:21:43 | Menard, Texas, US | |
1261963 | 1261963 | 2021-12-18 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-19 04:21:11 | Menard, Texas, US | |
2401991 | 2401991 | 2021-12-17 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-18 02:22:20 | Menard, Texas, US | |
2401225 | 2401225 | 2021-12-17 | US | North Dakota | Logan | 38047 | 346 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-18 02:22:20 | Logan, North Dakota, US | |
1719529 | 1719529 | 2021-12-16 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-17 04:22:14 | Menard, Texas, US | |
1718763 | 1718763 | 2021-12-16 | US | North Dakota | Logan | 38047 | 346 | 11 | 0 | 46.45729487 | -99.47719806 | 2021-12-17 04:22:14 | Logan, North Dakota, US | |
3499363 | 3499363 | 2021-12-15 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-16 04:22:11 | Menard, Texas, US | |
2091148 | 2091148 | 2021-12-14 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-15 03:22:16 | Menard, Texas, US | |
2089248 | 2089248 | 2021-12-14 | US | Kansas | Comanche | 20033 | 346 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-15 03:22:16 | Comanche, Kansas, US | |
785565 | 785565 | 2021-12-13 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-14 04:22:38 | Menard, Texas, US | |
783665 | 783665 | 2021-12-13 | US | Kansas | Comanche | 20033 | 346 | 13 | 0 | 37.19114520000001 | -99.27113247 | 2021-12-14 04:22:38 | Comanche, Kansas, US | |
1663600 | 1663600 | 2021-12-12 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-13 04:22:02 | Menard, Texas, US | |
1667616 | 1667616 | 2021-12-11 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-12 04:22:12 | Menard, Texas, US | |
3658768 | 3658768 | 2021-12-10 | US | Texas | Menard | 48327 | 346 | 11 | 0 | 30.88990665 | -99.82047940000001 | 2021-12-11 04:22:45 | Menard, Texas, US | |
1743432 | 1743432 | 2021-12-05 | US | South Dakota | Mellette | 46095 | 346 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-12-06 04:22:34 | Mellette, South Dakota, US | |
140864 | 140864 | 2021-12-04 | US | South Dakota | Mellette | 46095 | 346 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-12-05 04:22:25 | Mellette, South Dakota, US | |
2198517 | 2198517 | 2021-12-03 | US | South Dakota | Mellette | 46095 | 346 | 4 | 0 | 43.58078848 | -100.7563186 | 2021-12-04 04:22:18 | Mellette, South Dakota, US | |
906920 | 906920 | 2021-11-24 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-25 04:22:33 | Guanica, Puerto Rico, US | |
3072770 | 3072770 | 2021-11-23 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-24 04:22:14 | Guanica, Puerto Rico, US | |
3751868 | 3751868 | 2021-11-22 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-23 04:22:39 | Guanica, Puerto Rico, US | |
1017075 | 1017075 | 2021-11-21 | US | Puerto Rico | Guanica | 72055 | 346 | 0 | 0 | 17.982429 | -66.91964300000001 | 2021-11-22 04:22:20 | Guanica, Puerto Rico, US | |
1016725 | 1016725 | 2021-11-21 | US | North Dakota | Burke | 38013 | 346 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2021-11-22 04:22:20 | Burke, North Dakota, US | |
724889 | 724889 | 2021-11-20 | US | North Dakota | Burke | 38013 | 346 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2021-11-21 04:22:13 | Burke, North Dakota, US | |
3291318 | 3291318 | 2021-11-18 | US | North Dakota | Grant | 38037 | 346 | 8 | 0 | 46.35821257 | -101.63900129999999 | 2021-11-19 04:21:40 | Grant, North Dakota, US | |
2290536 | 2290536 | 2021-11-15 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-16 04:21:10 | Edwards, Texas, US | |
1325310 | 1325310 | 2021-11-14 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-15 04:21:36 | Edwards, Texas, US | |
689436 | 689436 | 2021-11-13 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-14 04:21:31 | Edwards, Texas, US | |
717545 | 717545 | 2021-11-12 | US | Texas | Edwards | 48137 | 346 | 8 | 0 | 29.98202582 | -100.304252 | 2021-11-13 04:21:38 | Edwards, Texas, US | |
2002745 | 2002745 | 2021-11-07 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-08 04:21:43 | Hitchcock, Nebraska, US | |
2002710 | 2002710 | 2021-11-07 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-08 04:21:43 | Brown, Nebraska, US | |
497736 | 497736 | 2021-11-06 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-07 04:21:53 | Hitchcock, Nebraska, US | |
497701 | 497701 | 2021-11-06 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-07 04:21:53 | Brown, Nebraska, US | |
3123591 | 3123591 | 2021-11-05 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-06 04:21:51 | Hitchcock, Nebraska, US | |
3123556 | 3123556 | 2021-11-05 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-06 04:21:51 | Brown, Nebraska, US | |
700489 | 700489 | 2021-11-04 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-05 04:21:54 | Hitchcock, Nebraska, US | |
700454 | 700454 | 2021-11-04 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-05 04:21:54 | Brown, Nebraska, US | |
278267 | 278267 | 2021-11-03 | US | Nebraska | Hitchcock | 31087 | 346 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-04 04:22:20 | Hitchcock, Nebraska, US | |
278232 | 278232 | 2021-11-03 | US | Nebraska | Brown | 31017 | 346 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-04 04:22:20 | Brown, Nebraska, US | |
275971 | 275971 | 2021-11-03 | China | Guangxi | 346 | 2 | 0 | 23.8298 | 108.7881 | 2021-11-04 04:22:20 | Guangxi, China | |||
684741 | 684741 | 2021-10-24 | US | North Dakota | Golden Valley | 38033 | 346 | 4 | 0 | 46.94022281 | -103.8465421 | 2021-10-25 04:22:31 | Golden Valley, North Dakota, US | |
425756 | 425756 | 2021-10-10 | US | North Dakota | Kidder | 38043 | 346 | 10 | 0 | 46.97830064 | -99.77507857 | 2021-10-11 04:21:31 | Kidder, North Dakota, US | |
1376911 | 1376911 | 2021-09-15 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-16 04:22:19 | Renville, North Dakota, US | |
2465210 | 2465210 | 2021-09-14 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-15 03:22:37 | Renville, North Dakota, US | |
1388049 | 1388049 | 2021-09-13 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-14 04:21:41 | Renville, North Dakota, US | |
1887418 | 1887418 | 2021-09-12 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-13 04:21:15 | Renville, North Dakota, US | |
3808321 | 3808321 | 2021-09-11 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-12 04:21:13 | Renville, North Dakota, US | |
3451261 | 3451261 | 2021-09-10 | US | North Dakota | Renville | 38075 | 346 | 14 | 0 | 48.71982533 | -101.6603912 | 2021-09-11 04:21:30 | Renville, North Dakota, US | |
1265441 | 1265441 | 2021-09-09 | US | Pennsylvania | Cameron | 42023 | 346 | 10 | 0 | 41.43625568 | -78.20376845 | 2021-09-10 04:21:20 | Cameron, Pennsylvania, US | |
249901 | 249901 | 2021-09-04 | US | Colorado | Gilpin | 8047 | 346 | 3 | 0 | 39.85646523 | -105.5252597 | 2021-09-05 04:21:33 | Gilpin, Colorado, US | |
181087 | 181087 | 2021-09-02 | US | Texas | Culberson | 48109 | 346 | 11 | 0 | 31.44506775 | -104.5185739 | 2021-09-03 04:21:20 | Culberson, Texas, US | |
178459 | 178459 | 2021-09-02 | US | Alaska | Prince of Wales-Hyder | 2198 | 346 | 5 | 0 | 55.76261984 | -133.0511621 | 2021-09-03 04:21:20 | Prince of Wales-Hyder, Alaska, US | |
69489 | 69489 | 2021-09-01 | US | North Dakota | Towner | 38095 | 346 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-09-02 04:21:15 | Towner, North Dakota, US | |
2068493 | 2068493 | 2021-08-31 | US | California | Unassigned | 90006 | 346 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-01 04:21:38 | Unassigned, California, US | |
3166430 | 3166430 | 2021-08-23 | US | Georgia | Glascock | 13125 | 346 | 19 | 0 | 33.22879932 | -82.61297636 | 2021-08-24 04:21:19 | Glascock, Georgia, US | |
3557885 | 3557885 | 2021-08-21 | US | New York | Hamilton | 36041 | 346 | 2 | 0 | 43.66146647 | -74.49721957 | 2021-08-22 04:21:29 | Hamilton, New York, US | |
2520105 | 2520105 | 2021-08-18 | US | Missouri | Mercer | 29129 | 346 | 2 | 0 | 40.42212303 | -93.56829590000001 | 2021-08-19 04:21:15 | Mercer, Missouri, US | |
3016383 | 3016383 | 2021-08-01 | US | Illinois | Pope | 17151 | 346 | 4 | 0 | 37.41391284 | -88.56152109 | 2021-08-02 04:21:36 | Pope, Illinois, US | |
3905006 | 3905006 | 2021-07-31 | US | Illinois | Pope | 17151 | 346 | 4 | 0 | 37.41391284 | -88.56152109 | 2021-08-01 04:21:50 | Pope, Illinois, US | |
3297211 | 3297211 | 2021-07-30 | US | Illinois | Pope | 17151 | 346 | 4 | 0 | 37.41391284 | -88.56152109 | 2021-07-31 04:21:35 | Pope, Illinois, US | |
1309393 | 1309393 | 2021-07-27 | US | Texas | Upton | 48461 | 346 | 10 | 0 | 31.36868194 | -102.0423217 | 2021-07-28 04:21:39 | Upton, Texas, US | |
3221536 | 3221536 | 2021-07-26 | US | Texas | Upton | 48461 | 346 | 10 | 0 | 31.36868194 | -102.0423217 | 2021-07-27 04:21:18 | Upton, Texas, US | |
1381745 | 1381745 | 2021-07-25 | US | Texas | Upton | 48461 | 346 | 10 | 0 | 31.36868194 | -102.0423217 | 2021-07-26 04:21:28 | Upton, Texas, 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]);