johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
695 rows where confirmed = 616 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717283 | 3717283 | 2022-12-06 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-07 04:20:58 | Hardeman, Texas, US | |
2417988 | 2417988 | 2022-12-05 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-06 04:21:03 | Hardeman, Texas, US | |
721596 | 721596 | 2022-12-04 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-05 04:20:58 | Hardeman, Texas, US | |
2819885 | 2819885 | 2022-12-03 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-04 04:20:56 | Hardeman, Texas, US | |
836741 | 836741 | 2022-12-02 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-03 04:21:02 | Hardeman, Texas, US | |
2139271 | 2139271 | 2022-12-01 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-02 04:21:07 | Hardeman, Texas, US | |
1967687 | 1967687 | 2022-11-30 | US | Texas | Hardeman | 48197 | 616 | 21 | 0 | 34.28944521 | -99.74632408 | 2022-12-01 04:21:03 | Hardeman, Texas, US | |
1643541 | 1643541 | 2022-11-20 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-21 04:21:05 | Oldham, Texas, US | |
2067098 | 2067098 | 2022-11-19 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-20 04:21:08 | Oldham, Texas, US | |
1758492 | 1758492 | 2022-11-18 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-19 04:21:14 | Oldham, Texas, US | |
3029485 | 3029485 | 2022-11-17 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-18 04:21:15 | Oldham, Texas, US | |
2489196 | 2489196 | 2022-11-16 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-17 04:21:11 | Oldham, Texas, US | |
295207 | 295207 | 2022-11-15 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-16 04:21:09 | Oldham, Texas, US | |
3600237 | 3600237 | 2022-11-14 | US | Texas | Oldham | 48359 | 616 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-11-15 04:21:16 | Oldham, Texas, US | |
117628 | 117628 | 2022-09-06 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-07 04:20:59 | Hand, South Dakota, US | |
2636600 | 2636600 | 2022-09-05 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-06 04:21:02 | Hand, South Dakota, US | |
2990164 | 2990164 | 2022-09-04 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-05 04:21:01 | Hand, South Dakota, US | |
2715849 | 2715849 | 2022-09-03 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-04 04:21:22 | Hand, South Dakota, US | |
1396554 | 1396554 | 2022-09-02 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-03 04:21:04 | Hand, South Dakota, US | |
3550383 | 3550383 | 2022-09-01 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-02 04:21:07 | Hand, South Dakota, US | |
2346303 | 2346303 | 2022-08-31 | US | South Dakota | Hand | 46059 | 616 | 13 | 0 | 44.54708407 | -99.00386459 | 2022-09-01 04:21:03 | Hand, South Dakota, US | |
1252049 | 1252049 | 2022-08-23 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-24 04:20:46 | Graham, Kansas, US | |
2854153 | 2854153 | 2022-08-22 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-23 04:20:56 | Graham, Kansas, US | |
2404125 | 2404125 | 2022-08-21 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-22 04:20:38 | Graham, Kansas, US | |
3799203 | 3799203 | 2022-08-20 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-21 04:20:44 | Graham, Kansas, US | |
2364789 | 2364789 | 2022-08-19 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-20 04:21:01 | Graham, Kansas, US | |
1162460 | 1162460 | 2022-08-18 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-19 04:20:54 | Graham, Kansas, US | |
3951784 | 3951784 | 2022-08-17 | US | Kansas | Graham | 20065 | 616 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-08-18 04:21:11 | Graham, Kansas, US | |
1088979 | 1088979 | 2022-08-09 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-10 04:20:57 | Sanborn, South Dakota, US | |
3546394 | 3546394 | 2022-08-08 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-09 04:20:34 | Sanborn, South Dakota, US | |
1072797 | 1072797 | 2022-08-07 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-08 04:21:08 | Sanborn, South Dakota, US | |
1943385 | 1943385 | 2022-08-06 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-07 04:20:54 | Sanborn, South Dakota, US | |
883184 | 883184 | 2022-08-05 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-06 04:20:56 | Sanborn, South Dakota, US | |
2011595 | 2011595 | 2022-08-04 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-05 04:20:52 | Sanborn, South Dakota, US | |
1101022 | 1101022 | 2022-08-03 | US | South Dakota | Sanborn | 46111 | 616 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-08-04 04:20:58 | Sanborn, South Dakota, US | |
961301 | 961301 | 2022-07-19 | US | North Dakota | Griggs | 38039 | 616 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-07-20 04:20:59 | Griggs, North Dakota, US | |
3943147 | 3943147 | 2022-06-30 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-07-01 04:21:10 | Fisher, Texas, US | |
2493105 | 2493105 | 2022-06-29 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-06-30 04:21:01 | Fisher, Texas, US | |
2242487 | 2242487 | 2022-06-28 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-06-29 04:20:59 | Fisher, Texas, US | |
2150729 | 2150729 | 2022-06-27 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-06-28 04:20:58 | Fisher, Texas, US | |
478530 | 478530 | 2022-06-26 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-06-27 04:21:00 | Fisher, Texas, US | |
941905 | 941905 | 2022-06-25 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-06-26 04:21:02 | Fisher, Texas, US | |
3349725 | 3349725 | 2022-06-24 | US | Texas | Fisher | 48151 | 616 | 24 | 0 | 32.74281316 | -100.4019302 | 2022-06-25 04:20:57 | Fisher, Texas, US | |
1765714 | 1765714 | 2022-06-20 | US | North Dakota | Adams | 38001 | 616 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-06-21 04:20:56 | Adams, North Dakota, US | |
972632 | 972632 | 2022-06-01 | US | Minnesota | Cook | 27031 | 616 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-06-02 05:20:39 | Cook, Minnesota, US | |
2599326 | 2599326 | 2022-05-05 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-05-06 04:21:00 | Decatur, Kansas, US | |
3266775 | 3266775 | 2022-05-04 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-05-05 04:20:55 | Decatur, Kansas, US | |
1573414 | 1573414 | 2022-05-03 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-05-04 04:20:59 | Decatur, Kansas, US | |
464674 | 464674 | 2022-05-02 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-05-03 04:21:00 | Decatur, Kansas, US | |
3917313 | 3917313 | 2022-05-01 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-05-02 04:21:10 | Decatur, Kansas, US | |
2842117 | 2842117 | 2022-04-30 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-05-01 04:20:57 | Decatur, Kansas, US | |
1158430 | 1158430 | 2022-04-29 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-04-30 04:21:05 | Decatur, Kansas, US | |
1697612 | 1697612 | 2022-04-28 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-04-29 04:20:59 | Decatur, Kansas, US | |
3853095 | 3853095 | 2022-04-27 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.4594081 | 2022-04-28 04:20:47 | Decatur, Kansas, US | |
1327525 | 1327525 | 2022-04-26 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-27 04:20:52 | Decatur, Kansas, US | |
3723479 | 3723479 | 2022-04-25 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-26 04:20:51 | Decatur, Kansas, US | |
2030047 | 2030047 | 2022-04-24 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-25 04:20:56 | Decatur, Kansas, US | |
747622 | 747622 | 2022-04-23 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-24 04:20:56 | Decatur, Kansas, US | |
3438107 | 3438107 | 2022-04-22 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-23 04:20:50 | Decatur, Kansas, US | |
2893692 | 2893692 | 2022-04-21 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-22 04:20:45 | Decatur, Kansas, US | |
2308564 | 2308564 | 2022-04-20 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-21 04:20:46 | Decatur, Kansas, US | |
2252703 | 2252703 | 2022-04-19 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-20 04:20:45 | Decatur, Kansas, US | |
1847253 | 1847253 | 2022-04-18 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-19 04:21:00 | Decatur, Kansas, US | |
3418197 | 3418197 | 2022-04-17 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-18 04:21:12 | Decatur, Kansas, US | |
305146 | 305146 | 2022-04-16 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-17 04:20:59 | Decatur, Kansas, US | |
2671091 | 2671091 | 2022-04-15 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-16 04:20:48 | Decatur, Kansas, US | |
1224876 | 1224876 | 2022-04-14 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-13 23:21:06 | Decatur, Kansas, US | |
2444034 | 2444034 | 2022-04-13 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-13 23:21:06 | Decatur, Kansas, US | |
1949791 | 1949791 | 2022-04-12 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-13 04:21:03 | Decatur, Kansas, US | |
1948938 | 1948938 | 2022-04-12 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-13 04:21:03 | Haines, Alaska, US | |
3207544 | 3207544 | 2022-04-11 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-12 04:20:49 | Decatur, Kansas, US | |
3206691 | 3206691 | 2022-04-11 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-12 04:20:49 | Haines, Alaska, US | |
1577430 | 1577430 | 2022-04-10 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-11 04:21:02 | Decatur, Kansas, US | |
1576577 | 1576577 | 2022-04-10 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-11 04:21:02 | Haines, Alaska, US | |
1653672 | 1653672 | 2022-04-09 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-10 04:20:52 | Decatur, Kansas, US | |
1652819 | 1652819 | 2022-04-09 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-10 04:20:52 | Haines, Alaska, US | |
2116994 | 2116994 | 2022-04-08 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-09 04:20:42 | Decatur, Kansas, US | |
2116141 | 2116141 | 2022-04-08 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-09 04:20:42 | Haines, Alaska, US | |
3321518 | 3321518 | 2022-04-07 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-08 04:20:48 | Decatur, Kansas, US | |
3320665 | 3320665 | 2022-04-07 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-08 04:20:48 | Haines, Alaska, US | |
2802054 | 2802054 | 2022-04-06 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-07 04:20:53 | Decatur, Kansas, US | |
2801201 | 2801201 | 2022-04-06 | US | Alaska | Haines | 2100 | 616 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-04-07 04:20:53 | Haines, Alaska, US | |
3868823 | 3868823 | 2022-04-05 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-06 04:20:49 | Decatur, Kansas, US | |
2750165 | 2750165 | 2022-04-04 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-05 04:20:48 | Decatur, Kansas, US | |
3731511 | 3731511 | 2022-04-03 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-04 04:20:51 | Decatur, Kansas, US | |
500946 | 500946 | 2022-04-02 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-03 04:20:48 | Decatur, Kansas, US | |
3351931 | 3351931 | 2022-04-01 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-02 04:20:47 | Decatur, Kansas, US | |
1541236 | 1541236 | 2022-03-31 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-04-01 04:20:28 | Decatur, Kansas, US | |
2479249 | 2479249 | 2022-03-30 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-31 04:20:56 | Decatur, Kansas, US | |
159290 | 159290 | 2022-03-29 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-30 04:20:45 | Decatur, Kansas, US | |
1437861 | 1437861 | 2022-03-28 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-29 04:20:46 | Decatur, Kansas, US | |
877542 | 877542 | 2022-03-27 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-28 04:20:33 | Decatur, Kansas, US | |
2164825 | 2164825 | 2022-03-26 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-27 04:20:47 | Decatur, Kansas, US | |
1721761 | 1721761 | 2022-03-25 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-26 04:20:23 | Decatur, Kansas, US | |
1469378 | 1469378 | 2022-03-24 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-25 04:20:46 | Decatur, Kansas, US | |
3023552 | 3023552 | 2022-03-23 | US | Kansas | Decatur | 20039 | 616 | 20 | 0 | 39.78468441 | -100.45940809999999 | 2022-03-24 04:20:43 | Decatur, Kansas, US | |
2732809 | 2732809 | 2022-02-27 | China | Chongqing | 616 | 6 | 0 | 30.0572 | 107.874 | 2022-02-28 04:21:05 | Chongqing, China | |||
3045962 | 3045962 | 2022-02-26 | China | Chongqing | 616 | 6 | 0 | 30.0572 | 107.874 | 2022-02-27 04:21:04 | Chongqing, China | |||
574617 | 574617 | 2022-02-25 | China | Chongqing | 616 | 6 | 0 | 30.0572 | 107.874 | 2022-02-26 04:21:12 | Chongqing, China | |||
2661010 | 2661010 | 2022-01-31 | US | Texas | Shackelford | 48417 | 616 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-02-01 04:21:11 | Shackelford, 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]);