johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where confirmed = 13330 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 42
- Nicaragua 7
- Colombia 1
- Jamaica 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
711317 | 711317 | 2022-11-01 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-11-02 04:22:09 | Polk, Georgia, US | |
3285766 | 3285766 | 2022-10-31 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-11-01 04:22:36 | Polk, Georgia, US | |
320799 | 320799 | 2022-10-30 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-31 04:21:36 | Polk, Georgia, US | |
913075 | 913075 | 2022-10-29 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-30 04:22:14 | Polk, Georgia, US | |
1367344 | 1367344 | 2022-10-28 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-29 04:21:13 | Polk, Georgia, US | |
3040611 | 3040611 | 2022-10-27 | US | New York | Tioga | 36107 | 13330 | 88 | 0 | 42.16852837 | -76.30835812 | 2022-10-28 04:22:31 | Tioga, New York, US | |
3039199 | 3039199 | 2022-10-27 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-28 04:22:31 | Polk, Georgia, US | |
539619 | 539619 | 2022-10-26 | US | Georgia | Polk | 13233 | 13330 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-27 04:22:01 | Polk, Georgia, US | |
2689284 | 2689284 | 2022-10-03 | US | Wisconsin | Shawano | 55115 | 13330 | 158 | 0 | 44.78902246 | -88.76443896 | 2022-10-04 04:22:55 | Shawano, Wisconsin, US | |
1625384 | 1625384 | 2022-09-22 | US | Indiana | Gibson | 18051 | 13330 | 154 | 0 | 38.30393723 | -87.58054938 | 2022-09-23 04:23:13 | Gibson, Indiana, US | |
1371588 | 1371588 | 2022-09-21 | US | Indiana | Gibson | 18051 | 13330 | 154 | 0 | 38.30393723 | -87.58054938 | 2022-09-22 04:22:56 | Gibson, Indiana, US | |
3942252 | 3942252 | 2022-06-30 | US | New Mexico | Curry | 35009 | 13330 | 210 | 0 | 34.57421077 | -103.3468876 | 2022-07-01 04:21:10 | Curry, New Mexico, US | |
559805 | 559805 | 2022-06-16 | US | Illinois | Henry | 17073 | 13330 | 121 | 0 | 41.3533994 | -90.13296166 | 2022-06-17 04:20:56 | Henry, Illinois, US | |
2895527 | 2895527 | 2022-04-21 | US | Texas | Harrison | 48203 | 13330 | 226 | 0 | 32.54935988 | -94.36934071 | 2022-04-22 04:20:45 | Harrison, Texas, US | |
2310399 | 2310399 | 2022-04-20 | US | Texas | Harrison | 48203 | 13330 | 226 | 0 | 32.54935988 | -94.36934071 | 2022-04-21 04:20:46 | Harrison, Texas, US | |
2254538 | 2254538 | 2022-04-19 | US | Texas | Harrison | 48203 | 13330 | 226 | 0 | 32.54935988 | -94.36934071 | 2022-04-20 04:20:45 | Harrison, Texas, US | |
3628317 | 3628317 | 2022-03-13 | US | Alabama | Coffee | 1031 | 13330 | 228 | 0 | 31.39932826 | -85.98901039 | 2022-03-14 04:20:46 | Coffee, Alabama, US | |
951225 | 951225 | 2022-03-12 | US | Alabama | Coffee | 1031 | 13330 | 228 | 0 | 31.39932826 | -85.98901039 | 2022-03-13 04:20:49 | Coffee, Alabama, US | |
356686 | 356686 | 2022-03-11 | US | Alabama | Coffee | 1031 | 13330 | 228 | 0 | 31.39932826 | -85.98901039 | 2022-03-12 04:20:50 | Coffee, Alabama, US | |
1550125 | 1550125 | 2022-03-07 | US | New Hampshire | Belknap | 33001 | 13330 | 170 | 0 | 43.51637314 | -71.41684235 | 2022-03-08 04:20:54 | Belknap, New Hampshire, US | |
2735367 | 2735367 | 2022-02-27 | US | North Carolina | McDowell | 37111 | 13330 | 159 | 0 | 35.67736232 | -82.0482425 | 2022-02-28 04:21:05 | McDowell, North Carolina, US | |
3048520 | 3048520 | 2022-02-26 | US | North Carolina | McDowell | 37111 | 13330 | 159 | 0 | 35.67736232 | -82.0482425 | 2022-02-27 04:21:04 | McDowell, North Carolina, US | |
577175 | 577175 | 2022-02-25 | US | North Carolina | McDowell | 37111 | 13330 | 159 | 0 | 35.67736232 | -82.0482425 | 2022-02-26 04:21:12 | McDowell, North Carolina, US | |
1320569 | 1320569 | 2022-01-26 | US | North Carolina | Pender | 37141 | 13330 | 106 | 0 | 34.52265624 | -77.90352133 | 2022-01-27 04:21:19 | Pender, North Carolina, US | |
1962871 | 1962871 | 2022-01-20 | US | North Carolina | Duplin | 37061 | 13330 | 203 | 0 | 34.93449805 | -77.93140529 | 2022-01-21 04:21:09 | Duplin, North Carolina, US | |
555600 | 555600 | 2022-01-16 | US | Georgia | Gordon | 13129 | 13330 | 214 | 0 | 34.50487351 | -84.87296253 | 2022-01-17 04:21:08 | Gordon, Georgia, US | |
3841321 | 3841321 | 2022-01-15 | US | Georgia | Gordon | 13129 | 13330 | 214 | 0 | 34.50487351 | -84.87296253 | 2022-01-16 04:21:12 | Gordon, Georgia, US | |
100136 | 100136 | 2022-01-14 | US | Georgia | Gordon | 13129 | 13330 | 214 | 0 | 34.50487351 | -84.87296253 | 2022-01-15 04:21:07 | Gordon, Georgia, US | |
3401578 | 3401578 | 2021-11-30 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-12-01 04:22:29 | Nicaragua | ||||
150121 | 150121 | 2021-11-29 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-11-30 04:22:53 | Nicaragua | ||||
1231767 | 1231767 | 2021-11-28 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-11-29 04:22:30 | Nicaragua | ||||
1358474 | 1358474 | 2021-11-27 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-11-28 04:22:43 | Nicaragua | ||||
758465 | 758465 | 2021-11-26 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-11-27 04:22:45 | Nicaragua | ||||
1802882 | 1802882 | 2021-11-25 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-11-26 04:22:33 | Nicaragua | ||||
904316 | 904316 | 2021-11-24 | Nicaragua | 13330 | 212 | 0 | 12.865416 | -85.207229 | 2021-11-25 04:22:33 | Nicaragua | ||||
3344809 | 3344809 | 2021-11-16 | US | New Mexico | Chaves | 35005 | 13330 | 213 | 0 | 33.36406072 | -104.4665365 | 2021-11-17 04:21:48 | Chaves, New Mexico, US | |
2694691 | 2694691 | 2021-07-06 | US | Illinois | Kendall | 17093 | 13330 | 99 | 0 | 41.59081014 | -88.42869583 | 2021-07-07 04:21:20 | Kendall, Illinois, US | |
84837 | 84837 | 2021-05-25 | US | Minnesota | Olmsted | 27109 | 13330 | 102 | 0 | 44.00374114 | -92.40209944 | 2021-05-26 04:20:35 | Olmsted, Minnesota, US | |
1569693 | 1569693 | 2021-04-22 | US | Massachusetts | Barnstable | 25001 | 13330 | 368 | 0 | 41.72980578 | -70.28854339 | 2021-04-23 04:20:52 | Barnstable, Massachusetts, US | |
1673120 | 1673120 | 2021-02-07 | US | Delaware | Kent | 10001 | 13330 | 279 | 0 | 13051 | 39.08646628 | -75.56884914 | 2021-02-08 05:22:39 | Kent, Delaware, US |
1588941 | 1588941 | 2021-02-05 | US | Georgia | Clarke | 13059 | 13330 | 99 | 0 | 13231 | 33.95436462 | -83.37124007 | 2021-02-06 05:23:55 | Clarke, Georgia, US |
2214119 | 2214119 | 2021-01-30 | US | Ohio | Fairfield | 39045 | 13330 | 172 | 0 | 13158 | 39.75107189 | -82.63088163 | 2021-01-31 05:22:42 | Fairfield, Ohio, US |
3103013 | 3103013 | 2021-01-16 | US | Maryland | Howard | 24027 | 13330 | 192 | 0 | 13138 | 39.25305293 | -76.93126208 | 2021-01-17 05:22:17 | Howard, Maryland, US |
3881865 | 3881865 | 2021-01-14 | US | North Carolina | Catawba | 37035 | 13330 | 201 | 0 | 13129 | 35.66211129 | -81.2132617 | 2021-01-15 05:22:24 | Catawba, North Carolina, US |
2864715 | 2864715 | 2021-01-06 | Jamaica | 13330 | 306 | 11182 | 1842 | 18.1096 | -77.2975 | 2021-01-07 05:22:03 | Jamaica | |||
2931072 | 2931072 | 2020-12-19 | Colombia | La Guajira | 13330 | 520 | 12216 | 594 | 11.3548 | -72.5205 | 2020-12-20 05:27:32 | La Guajira, Colombia | ||
1587409 | 1587409 | 2020-11-30 | US | Texas | Williamson | 48491 | 13330 | 165 | 0 | 13409 | 30.64655664 | -97.6004854 | 2020-12-01 05:26:18 | Williamson, Texas, US |
1455532 | 1455532 | 2020-10-27 | US | Tennessee | Knox | 47093 | 13330 | 92 | 0 | 12864 | 35.99508821 | -83.94635435 | 2020-10-28 04:24:39 | Knox, Tennessee, US |
3782576 | 3782576 | 2020-10-13 | US | Florida | Collier | 12021 | 13330 | 239 | 0 | 13091 | 26.11091986 | -81.34687065 | 2020-10-14 04:24:05 | Collier, Florida, US |
2455815 | 2455815 | 2020-09-19 | US | Illinois | Will | 17197 | 13330 | 372 | 0 | 12958 | 41.44619267 | -87.97862712 | 2020-09-20 04:22:00 | Will, Illinois, US |
347533 | 347533 | 2020-09-14 | US | Utah | Utah | 49049 | 13330 | 53 | 0 | 13277 | 40.1166722 | -111.6657662 | 2020-09-15 03:22:50 | Utah, Utah, US |
813699 | 813699 | 2020-09-05 | Netherlands | Noord-Holland | 13330 | 832 | 0 | 12460 | 52.60090600000001 | 4.918688 | 2020-09-06 04:28:33 | Noord-Holland, Netherlands |
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]);