johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where confirmed = 12200 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954636 | 2954636 | 2022-12-20 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-21 04:21:03 | Van Zandt, Texas, US | |
3177038 | 3177038 | 2022-12-19 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-20 04:21:04 | Van Zandt, Texas, US | |
1631555 | 1631555 | 2022-12-18 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-19 04:21:03 | Van Zandt, Texas, US | |
506934 | 506934 | 2022-12-17 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-18 04:21:03 | Van Zandt, Texas, US | |
3327506 | 3327506 | 2022-12-16 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-17 04:21:04 | Van Zandt, Texas, US | |
546018 | 546018 | 2022-12-15 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-16 04:21:01 | Van Zandt, Texas, US | |
351546 | 351546 | 2022-12-14 | US | Texas | Van Zandt | 48467 | 12200 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-12-15 04:20:58 | Van Zandt, Texas, US | |
852178 | 852178 | 2022-11-02 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-11-03 04:22:05 | Mayes, Oklahoma, US | |
713029 | 713029 | 2022-11-01 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-11-02 04:22:09 | Mayes, Oklahoma, US | |
3287478 | 3287478 | 2022-10-31 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-11-01 04:22:36 | Mayes, Oklahoma, US | |
322511 | 322511 | 2022-10-30 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-10-31 04:21:36 | Mayes, Oklahoma, US | |
914787 | 914787 | 2022-10-29 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-10-30 04:22:14 | Mayes, Oklahoma, US | |
1369056 | 1369056 | 2022-10-28 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-10-29 04:21:13 | Mayes, Oklahoma, US | |
3040911 | 3040911 | 2022-10-27 | US | Oklahoma | Mayes | 40097 | 12200 | 169 | 0 | 36.30179091 | -95.23175116 | 2022-10-28 04:22:31 | Mayes, Oklahoma, US | |
132274 | 132274 | 2022-10-04 | US | Louisiana | Natchitoches | 22069 | 12200 | 182 | 0 | 31.72321584 | -93.09816516 | 2022-10-05 04:23:06 | Natchitoches, Louisiana, US | |
3572859 | 3572859 | 2022-09-19 | US | New York | Otsego | 36077 | 12200 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-20 04:22:48 | Otsego, New York, US | |
2743288 | 2743288 | 2022-07-07 | US | New York | Tioga | 36107 | 12200 | 86 | 0 | 42.16852837 | -76.30835812 | 2022-07-08 04:20:56 | Tioga, New York, US | |
2742954 | 2742954 | 2022-07-07 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-08 04:20:56 | Newton, Missouri, US | |
1202083 | 1202083 | 2022-07-06 | US | New York | Tioga | 36107 | 12200 | 86 | 0 | 42.16852837 | -76.30835812 | 2022-07-07 04:20:55 | Tioga, New York, US | |
1201749 | 1201749 | 2022-07-06 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-07 04:20:55 | Newton, Missouri, US | |
3968492 | 3968492 | 2022-07-05 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-06 04:20:58 | Newton, Missouri, US | |
3080003 | 3080003 | 2022-07-04 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-05 04:20:45 | Newton, Missouri, US | |
1769285 | 1769285 | 2022-07-03 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-04 04:20:54 | Newton, Missouri, US | |
3367271 | 3367271 | 2022-07-02 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-03 04:20:59 | Newton, Missouri, US | |
595600 | 595600 | 2022-07-01 | US | Missouri | Newton | 29145 | 12200 | 208 | 0 | 36.90519407 | -94.3394104 | 2022-07-02 04:21:16 | Newton, Missouri, US | |
2050657 | 2050657 | 2022-05-25 | US | Puerto Rico | Vega Baja | 72145 | 12200 | 0 | 0 | 18.428262 | -66.397924 | 2022-05-26 04:20:50 | Vega Baja, Puerto Rico, US | |
624668 | 624668 | 2022-05-22 | US | Puerto Rico | Vega Baja | 72145 | 12200 | 0 | 0 | 18.428262 | -66.397924 | 2022-05-26 04:20:50 | Vega Baja, Puerto Rico, US | |
1647051 | 1647051 | 2022-03-03 | US | Pennsylvania | Mifflin | 42087 | 12200 | 274 | 0 | 40.61116939 | -77.61070738 | 2022-03-04 04:21:09 | Mifflin, Pennsylvania, US | |
1363890 | 1363890 | 2022-02-08 | US | Louisiana | St. Mary | 22101 | 12200 | 251 | 0 | 29.69262097 | -91.44702164 | 2022-02-09 04:21:04 | St. Mary, Louisiana, US | |
1392601 | 1392601 | 2022-01-07 | US | Tennessee | Gibson | 47053 | 12200 | 212 | 0 | 35.99438059 | -88.93358327 | 2022-01-08 04:21:53 | Gibson, Tennessee, US | |
783984 | 783984 | 2021-12-13 | US | Maryland | Wicomico | 24045 | 12200 | 236 | 0 | 38.37301947 | -75.62705831 | 2021-12-14 04:22:38 | Wicomico, Maryland, US | |
1031530 | 1031530 | 2021-12-06 | US | Indiana | Wayne | 18177 | 12200 | 269 | 0 | 39.863344399999995 | -85.01044989 | 2021-12-07 04:22:34 | Wayne, Indiana, US | |
279586 | 279586 | 2021-11-03 | US | Virginia | Roanoke City | 51770 | 12200 | 241 | 0 | 37.27791025 | -79.96189766 | 2021-11-04 04:22:20 | Roanoke City, Virginia, US | |
1494230 | 1494230 | 2021-10-12 | US | Oregon | Linn | 41043 | 12200 | 114 | 0 | 44.48899494 | -122.53731540000001 | 2021-10-13 04:20:51 | Linn, Oregon, US | |
68858 | 68858 | 2021-09-01 | US | Mississippi | Forrest | 28035 | 12200 | 209 | 0 | 31.18961454 | -89.25832496 | 2021-09-02 04:21:15 | Forrest, Mississippi, US | |
1120571 | 1120571 | 2021-08-06 | US | Tennessee | Putnam | 47141 | 12200 | 182 | 0 | 36.14005459 | -85.50646123 | 2021-08-07 04:21:30 | Putnam, Tennessee, US | |
1414158 | 1414158 | 2021-05-24 | US | Indiana | LaPorte | 18091 | 12200 | 217 | 0 | 41.54366008 | -86.74072188 | 2021-05-25 04:21:08 | LaPorte, Indiana, US | |
1916204 | 1916204 | 2021-05-20 | US | Tennessee | Unassigned | 90047 | 12200 | 131 | 0 | 36.55606529 | 0.0 | 2021-05-21 04:20:43 | Unassigned, Tennessee, US | |
3254107 | 3254107 | 2021-03-02 | India | Nagaland | 12200 | 91 | 12102 | 7 | 26.06702 | 94.470302 | 2021-03-03 05:23:28 | Nagaland, India | ||
998399 | 998399 | 2021-03-01 | India | Nagaland | 12200 | 91 | 12102 | 7 | 26.06702 | 94.470302 | 2021-03-02 05:23:30 | Nagaland, India | ||
2367457 | 2367457 | 2021-02-28 | India | Nagaland | 12200 | 91 | 12102 | 7 | 26.06702 | 94.470302 | 2021-03-01 05:23:01 | Nagaland, India | ||
1339271 | 1339271 | 2021-02-15 | US | Illinois | Kankakee | 17091 | 12200 | 186 | 0 | 12014 | 41.13746989 | -87.86205334 | 2021-02-16 05:24:38 | Kankakee, Illinois, US |
616336 | 616336 | 2021-02-08 | US | Pennsylvania | Centre | 42027 | 12200 | 200 | 0 | 12000 | 40.92058903 | -77.82200624 | 2021-02-09 05:23:30 | Centre, Pennsylvania, US |
436555 | 436555 | 2021-01-21 | US | Iowa | Johnson | 19103 | 12200 | 51 | 0 | 12149 | 41.67169354 | -91.58754744 | 2021-01-22 05:22:10 | Johnson, Iowa, US |
777001 | 777001 | 2021-01-12 | US | Pennsylvania | Cumberland | 42041 | 12200 | 352 | 0 | 11848 | 40.1625372 | -77.26130755 | 2021-01-13 05:22:15 | Cumberland, Pennsylvania, US |
2350054 | 2350054 | 2020-12-07 | US | Oregon | Washington | 41067 | 12200 | 109 | 0 | 12091 | 45.55972701 | -123.0955257 | 2020-12-08 05:27:42 | Washington, Oregon, US |
77194 | 77194 | 2020-12-03 | US | Nebraska | Sarpy | 31153 | 12200 | 60 | 0 | 12140 | 41.11314181 | -96.11156432 | 2020-12-04 05:27:27 | Sarpy, Nebraska, US |
1795290 | 1795290 | 2020-10-19 | US | Delaware | New Castle | 10003 | 12200 | 352 | 0 | 11848 | 39.57992638 | -75.64054974 | 2020-10-20 04:24:22 | New Castle, Delaware, US |
582678 | 582678 | 2020-08-13 | Colombia | Cordoba | 12200 | 909 | 5446 | 5845 | 8.0493 | -75.574 | 2020-08-14 04:51:19 | Cordoba, Colombia |
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]);