johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
677 rows where confirmed = 519 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755095 | 2755095 | 2022-12-29 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-30 04:21:04 | Catron, New Mexico, US | |
1076101 | 1076101 | 2022-12-28 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-29 04:21:01 | Catron, New Mexico, US | |
330098 | 330098 | 2022-12-27 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-28 04:21:04 | Catron, New Mexico, US | |
220171 | 220171 | 2022-12-26 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-27 04:21:07 | Catron, New Mexico, US | |
3224628 | 3224628 | 2022-12-25 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-26 04:21:06 | Catron, New Mexico, US | |
1020542 | 1020542 | 2022-12-24 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-25 04:21:04 | Catron, New Mexico, US | |
692565 | 692565 | 2022-12-23 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-24 04:21:02 | Catron, New Mexico, US | |
2181775 | 2181775 | 2022-12-22 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-23 04:21:04 | Catron, New Mexico, US | |
453579 | 453579 | 2022-12-21 | US | New Mexico | Catron | 35003 | 519 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-12-22 04:20:56 | Catron, New Mexico, US | |
1623169 | 1623169 | 2022-11-22 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-23 04:21:06 | McPherson, South Dakota, US | |
3463057 | 3463057 | 2022-11-21 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-22 04:20:47 | McPherson, South Dakota, US | |
1643242 | 1643242 | 2022-11-20 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-21 04:21:05 | McPherson, South Dakota, US | |
2066799 | 2066799 | 2022-11-19 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-20 04:21:08 | McPherson, South Dakota, US | |
1758193 | 1758193 | 2022-11-18 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-19 04:21:14 | McPherson, South Dakota, US | |
3029186 | 3029186 | 2022-11-17 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-18 04:21:15 | McPherson, South Dakota, US | |
2488897 | 2488897 | 2022-11-16 | US | South Dakota | McPherson | 46089 | 519 | 14 | 0 | 45.76626028 | -99.22118798 | 2022-11-17 04:21:11 | McPherson, South Dakota, US | |
2531794 | 2531794 | 2022-10-06 | US | North Dakota | Logan | 38047 | 519 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-10-07 04:23:08 | Logan, North Dakota, US | |
1813188 | 1813188 | 2022-10-05 | US | North Dakota | Logan | 38047 | 519 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-10-06 04:21:22 | Logan, North Dakota, US | |
3997043 | 3997043 | 2022-09-27 | US | North Dakota | Grant | 38037 | 519 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-09-28 04:23:01 | Grant, North Dakota, US | |
3988642 | 3988642 | 2022-09-15 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-16 04:21:19 | Meagher, Montana, US | |
1891159 | 1891159 | 2022-09-14 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-15 04:21:02 | Meagher, Montana, US | |
374214 | 374214 | 2022-09-13 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-14 04:20:44 | Meagher, Montana, US | |
2396816 | 2396816 | 2022-09-12 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-13 04:20:57 | Meagher, Montana, US | |
3767894 | 3767894 | 2022-09-11 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-12 04:20:58 | Meagher, Montana, US | |
3826469 | 3826469 | 2022-09-10 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-11 04:20:50 | Meagher, Montana, US | |
964926 | 964926 | 2022-09-09 | US | Montana | Meagher | 30059 | 519 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-09-10 04:21:10 | Meagher, Montana, US | |
1252054 | 1252054 | 2022-08-23 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-24 04:20:46 | Hamilton, Kansas, US | |
2854158 | 2854158 | 2022-08-22 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-23 04:20:56 | Hamilton, Kansas, US | |
2853520 | 2853520 | 2022-08-22 | US | Colorado | Sedgwick | 8115 | 519 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-08-23 04:20:56 | Sedgwick, Colorado, US | |
2404130 | 2404130 | 2022-08-21 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-22 04:20:38 | Hamilton, Kansas, US | |
2403492 | 2403492 | 2022-08-21 | US | Colorado | Sedgwick | 8115 | 519 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-08-22 04:20:38 | Sedgwick, Colorado, US | |
3799208 | 3799208 | 2022-08-20 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-21 04:20:44 | Hamilton, Kansas, US | |
3798570 | 3798570 | 2022-08-20 | US | Colorado | Sedgwick | 8115 | 519 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-08-21 04:20:44 | Sedgwick, Colorado, US | |
2364794 | 2364794 | 2022-08-19 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-20 04:21:01 | Hamilton, Kansas, US | |
2364156 | 2364156 | 2022-08-19 | US | Colorado | Sedgwick | 8115 | 519 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-08-20 04:21:01 | Sedgwick, Colorado, US | |
1162465 | 1162465 | 2022-08-18 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-19 04:20:54 | Hamilton, Kansas, US | |
1161827 | 1161827 | 2022-08-18 | US | Colorado | Sedgwick | 8115 | 519 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-08-19 04:20:54 | Sedgwick, Colorado, US | |
3951789 | 3951789 | 2022-08-17 | US | Kansas | Hamilton | 20075 | 519 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-08-18 04:21:11 | Hamilton, Kansas, US | |
3650664 | 3650664 | 2022-08-14 | US | Texas | Edwards | 48137 | 519 | 11 | 0 | 29.98202582 | -100.304252 | 2022-08-15 04:20:59 | Edwards, Texas, US | |
1971670 | 1971670 | 2022-08-13 | US | Texas | Edwards | 48137 | 519 | 11 | 0 | 29.98202582 | -100.304252 | 2022-08-14 04:20:55 | Edwards, Texas, US | |
2891479 | 2891479 | 2022-08-12 | US | Texas | Edwards | 48137 | 519 | 11 | 0 | 29.98202582 | -100.304252 | 2022-08-13 04:20:52 | Edwards, Texas, US | |
2890796 | 2890796 | 2022-08-12 | US | North Dakota | Divide | 38023 | 519 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-08-13 04:20:52 | Divide, North Dakota, US | |
632975 | 632975 | 2022-07-12 | US | Texas | Culberson | 48109 | 519 | 14 | 0 | 31.44506775 | -104.5185739 | 2022-07-13 04:20:58 | Culberson, Texas, US | |
3001356 | 3001356 | 2022-05-24 | US | Nebraska | Brown | 31017 | 519 | 4 | 0 | 42.43018907 | -99.92904055 | 2022-05-25 04:20:56 | Brown, Nebraska, US | |
3595077 | 3595077 | 2022-05-23 | US | Nebraska | Brown | 31017 | 519 | 4 | 0 | 42.43018907 | -99.92904055 | 2022-05-24 04:20:57 | Brown, Nebraska, US | |
3419680 | 3419680 | 2022-04-17 | US | Puerto Rico | Maricao | 72093 | 519 | 0 | 0 | 18.171795 | -66.942126 | 2022-04-18 04:21:12 | Maricao, Puerto Rico, US | |
2321890 | 2321890 | 2022-03-16 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-17 04:20:56 | Harmon, Oklahoma, US | |
264090 | 264090 | 2022-03-15 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-16 04:20:50 | Harmon, Oklahoma, US | |
2266449 | 2266449 | 2022-03-14 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-15 04:20:47 | Harmon, Oklahoma, US | |
3630515 | 3630515 | 2022-03-13 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-14 04:20:46 | Harmon, Oklahoma, US | |
3628400 | 3628400 | 2022-03-13 | US | Alaska | Yakutat | 2282 | 519 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-03-14 04:20:46 | Yakutat, Alaska, US | |
953423 | 953423 | 2022-03-12 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-13 04:20:49 | Harmon, Oklahoma, US | |
951308 | 951308 | 2022-03-12 | US | Alaska | Yakutat | 2282 | 519 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-03-13 04:20:49 | Yakutat, Alaska, US | |
358884 | 358884 | 2022-03-11 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-12 04:20:50 | Harmon, Oklahoma, US | |
356769 | 356769 | 2022-03-11 | US | Alaska | Yakutat | 2282 | 519 | 5 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-03-12 04:20:50 | Yakutat, Alaska, US | |
1868036 | 1868036 | 2022-03-10 | US | Oklahoma | Harmon | 40057 | 519 | 11 | 0 | 34.7440135 | -99.84741652 | 2022-03-11 04:20:50 | Harmon, Oklahoma, US | |
923150 | 923150 | 2022-03-08 | US | Washington | Wahkiakum | 53069 | 519 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-03-09 04:20:59 | Wahkiakum, Washington, US | |
1551437 | 1551437 | 2022-03-07 | US | Washington | Wahkiakum | 53069 | 519 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-03-08 04:20:54 | Wahkiakum, Washington, US | |
1514626 | 1514626 | 2022-02-24 | US | Texas | Schleicher | 48413 | 519 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-25 04:21:11 | Schleicher, Texas, US | |
1061067 | 1061067 | 2022-02-23 | US | Texas | Schleicher | 48413 | 519 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-24 04:21:14 | Schleicher, Texas, US | |
2449990 | 2449990 | 2022-02-22 | US | Texas | Schleicher | 48413 | 519 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-23 04:21:09 | Schleicher, Texas, US | |
3721403 | 3721403 | 2022-02-21 | US | Texas | Schleicher | 48413 | 519 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-22 04:21:01 | Schleicher, Texas, US | |
3720258 | 3720258 | 2022-02-21 | US | Nebraska | Frontier | 31063 | 519 | 1 | 0 | 40.52993007 | -100.3924658 | 2022-02-22 04:21:01 | Frontier, Nebraska, US | |
3915237 | 3915237 | 2022-02-20 | US | Texas | Schleicher | 48413 | 519 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-21 04:21:05 | Schleicher, Texas, US | |
3878795 | 3878795 | 2022-02-19 | US | Texas | Schleicher | 48413 | 519 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-20 04:21:00 | Schleicher, Texas, US | |
1467275 | 1467275 | 2022-02-10 | US | Texas | Oldham | 48359 | 519 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-02-11 04:21:09 | Oldham, Texas, US | |
1466157 | 1466157 | 2022-02-10 | US | Nebraska | Frontier | 31063 | 519 | 1 | 0 | 40.52993007 | -100.3924658 | 2022-02-11 04:21:09 | Frontier, Nebraska, US | |
1465796 | 1465796 | 2022-02-10 | US | Minnesota | Cook | 27031 | 519 | 3 | 0 | 47.90504893 | -90.52629546 | 2022-02-11 04:21:09 | Cook, Minnesota, US | |
3076118 | 3076118 | 2022-02-09 | US | Nebraska | Frontier | 31063 | 519 | 1 | 0 | 40.52993007 | -100.3924658 | 2022-02-10 04:21:14 | Frontier, Nebraska, US | |
1364064 | 1364064 | 2022-02-08 | US | Minnesota | Cook | 27031 | 519 | 2 | 0 | 47.90504893 | -90.52629546 | 2022-02-09 04:21:04 | Cook, Minnesota, US | |
2660704 | 2660704 | 2022-01-31 | US | South Dakota | Ziebach | 46137 | 519 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-01 04:21:11 | Ziebach, South Dakota, US | |
3302400 | 3302400 | 2022-01-30 | US | New Mexico | De Baca | 35011 | 519 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-01-31 04:21:09 | De Baca, New Mexico, US | |
3064421 | 3064421 | 2022-01-29 | US | North Dakota | Renville | 38075 | 519 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-01-30 04:21:26 | Renville, North Dakota, US | |
3064191 | 3064191 | 2022-01-29 | US | New Mexico | De Baca | 35011 | 519 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-01-30 04:21:26 | De Baca, New Mexico, US | |
3812125 | 3812125 | 2022-01-28 | US | New Mexico | De Baca | 35011 | 519 | 5 | 0 | 34.34274529 | -104.4117842 | 2022-01-29 04:21:10 | De Baca, New Mexico, US | |
1781443 | 1781443 | 2022-01-27 | US | Nebraska | Cherry | 31031 | 519 | 7 | 0 | 42.54502621 | -101.1244332 | 2022-01-28 04:21:09 | Cherry, Nebraska, US | |
3227260 | 3227260 | 2022-01-19 | US | Georgia | Glascock | 13125 | 519 | 22 | 0 | 33.22879932 | -82.61297636 | 2022-01-20 04:21:07 | Glascock, Georgia, US | |
1475728 | 1475728 | 2022-01-17 | US | Wyoming | Niobrara | 56027 | 519 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-18 04:21:04 | Niobrara, Wyoming, US | |
1475202 | 1475202 | 2022-01-17 | US | Texas | Fisher | 48151 | 519 | 20 | 0 | 32.74281316 | -100.40193020000001 | 2022-01-18 04:21:04 | Fisher, Texas, US | |
558402 | 558402 | 2022-01-16 | US | Wyoming | Niobrara | 56027 | 519 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-17 04:21:08 | Niobrara, Wyoming, US | |
3844123 | 3844123 | 2022-01-15 | US | Wyoming | Niobrara | 56027 | 519 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-16 04:21:12 | Niobrara, Wyoming, US | |
102938 | 102938 | 2022-01-14 | US | Wyoming | Niobrara | 56027 | 519 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-15 04:21:07 | Niobrara, Wyoming, US | |
2611398 | 2611398 | 2022-01-06 | US | Kansas | Smith | 20183 | 519 | 5 | 0 | 39.78516566 | -98.78566062 | 2022-01-07 04:22:09 | Smith, Kansas, US | |
1283340 | 1283340 | 2022-01-05 | US | Kansas | Smith | 20183 | 519 | 5 | 0 | 39.78516566 | -98.78566062 | 2022-01-06 04:22:09 | Smith, Kansas, US | |
1287967 | 1287967 | 2022-01-04 | US | Missouri | Scotland | 29199 | 519 | 17 | 0 | 40.45214695 | -92.14709064 | 2022-01-05 04:21:59 | Scotland, Missouri, US | |
3522333 | 3522333 | 2022-01-02 | US | South Dakota | Potter | 46107 | 519 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-03 02:22:25 | Potter, South Dakota, US | |
2170463 | 2170463 | 2022-01-01 | US | South Dakota | Potter | 46107 | 519 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-02 04:20:52 | Potter, South Dakota, US | |
2779894 | 2779894 | 2021-12-31 | US | South Dakota | Potter | 46107 | 519 | 5 | 0 | 45.06583079 | -99.95498503 | 2022-01-01 04:22:14 | Potter, South Dakota, US | |
4001551 | 4001551 | 2021-12-30 | US | South Dakota | Potter | 46107 | 519 | 5 | 0 | 45.06583079 | -99.95498503 | 2021-12-31 04:21:50 | Potter, South Dakota, US | |
733432 | 733432 | 2021-12-27 | US | South Dakota | Stanley | 46117 | 519 | 3 | 0 | 44.41381872 | -100.7349153 | 2021-12-28 04:21:47 | Stanley, South Dakota, US | |
1718315 | 1718315 | 2021-12-16 | US | Missouri | Schuyler | 29197 | 519 | 22 | 0 | 40.46921489 | -92.52311943 | 2021-12-17 04:22:14 | Schuyler, Missouri, US | |
783636 | 783636 | 2021-12-13 | US | Iowa | Unassigned | 90019 | 519 | 0 | 0 | 43.38107862 | 0.0 | 2021-12-14 04:22:38 | Unassigned, Iowa, US | |
1661671 | 1661671 | 2021-12-12 | US | Iowa | Unassigned | 90019 | 519 | 0 | 0 | 43.38107862 | 0.0 | 2021-12-13 04:22:02 | Unassigned, Iowa, US | |
1665687 | 1665687 | 2021-12-11 | US | Iowa | Unassigned | 90019 | 519 | 0 | 0 | 43.38107862 | 0.0 | 2021-12-12 04:22:12 | Unassigned, Iowa, US | |
1032786 | 1032786 | 2021-12-06 | US | North Dakota | McIntosh | 38051 | 519 | 9 | 0 | 46.11182017 | -99.44145858 | 2021-12-07 04:22:34 | McIntosh, North Dakota, US | |
1743844 | 1743844 | 2021-12-05 | US | Virginia | Bath | 51017 | 519 | 15 | 0 | 38.05852573 | -79.73912095 | 2021-12-06 04:22:34 | Bath, Virginia, US | |
1742949 | 1742949 | 2021-12-05 | US | North Dakota | McIntosh | 38051 | 519 | 9 | 0 | 46.11182017 | -99.44145858 | 2021-12-06 04:22:34 | McIntosh, North Dakota, US | |
141276 | 141276 | 2021-12-04 | US | Virginia | Bath | 51017 | 519 | 15 | 0 | 38.05852573 | -79.73912095 | 2021-12-05 04:22:25 | Bath, Virginia, US | |
140381 | 140381 | 2021-12-04 | US | North Dakota | McIntosh | 38051 | 519 | 9 | 0 | 46.11182017 | -99.44145858 | 2021-12-05 04:22:25 | McIntosh, North Dakota, US | |
2198929 | 2198929 | 2021-12-03 | US | Virginia | Bath | 51017 | 519 | 15 | 0 | 38.05852573 | -79.73912095 | 2021-12-04 04:22:18 | Bath, Virginia, 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]);