johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 10869 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
312083 | 312083 | 2022-11-13 | Peru | Unknown | 10869 | 112 | 0 | 2022-11-14 04:21:09 | Unknown, Peru | |||||
1050870 | 1050870 | 2022-11-06 | US | Illinois | Monroe | 17133 | 10869 | 134 | 0 | 38.27594376 | -90.17761038 | 2022-11-07 04:21:26 | Monroe, Illinois, US | |
618894 | 618894 | 2022-11-05 | US | Illinois | Monroe | 17133 | 10869 | 134 | 0 | 38.27594376 | -90.17761038 | 2022-11-06 04:21:24 | Monroe, Illinois, US | |
1023398 | 1023398 | 2022-11-04 | US | Illinois | Monroe | 17133 | 10869 | 134 | 0 | 38.27594376 | -90.17761038 | 2022-11-05 04:21:52 | Monroe, Illinois, US | |
2772378 | 2772378 | 2022-09-26 | US | Virginia | Smyth | 51173 | 10869 | 186 | 0 | 36.84455636 | -81.53344948 | 2022-09-27 04:23:01 | Smyth, Virginia, US | |
1373869 | 1373869 | 2022-09-21 | US | Virginia | Manassas | 51683 | 10869 | 74 | 0 | 38.7464321 | -77.48509905 | 2022-09-22 04:22:56 | Manassas, Virginia, US | |
2242116 | 2242116 | 2022-06-28 | US | Puerto Rico | Aguadilla | 72005 | 10869 | 0 | 0 | 18.459681 | -67.120815 | 2022-06-29 04:20:59 | Aguadilla, Puerto Rico, US | |
2536609 | 2536609 | 2022-05-12 | US | Texas | Rusk | 48401 | 10869 | 232 | 0 | 32.10773545 | -94.76176432 | 2022-05-13 04:20:51 | Rusk, Texas, US | |
3448055 | 3448055 | 2022-05-11 | US | Texas | Rusk | 48401 | 10869 | 232 | 0 | 32.10773545 | -94.76176432 | 2022-05-12 04:20:54 | Rusk, Texas, US | |
466736 | 466736 | 2022-05-02 | US | Virginia | Franklin | 51067 | 10869 | 197 | 0 | 36.99536167 | -79.88023649 | 2022-05-03 04:21:00 | Franklin, Virginia, US | |
3869262 | 3869262 | 2022-04-05 | US | Minnesota | Douglas | 27041 | 10869 | 116 | 0 | 45.93348491 | -95.45335469 | 2022-04-06 04:20:49 | Douglas, Minnesota, US | |
2449322 | 2449322 | 2022-02-22 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-23 04:21:09 | Delaware, Oklahoma, US | |
3720735 | 3720735 | 2022-02-21 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-22 04:21:01 | Delaware, Oklahoma, US | |
3914569 | 3914569 | 2022-02-20 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-21 04:21:05 | Delaware, Oklahoma, US | |
3878127 | 3878127 | 2022-02-19 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-20 04:21:00 | Delaware, Oklahoma, US | |
3858383 | 3858383 | 2022-02-18 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-19 04:21:11 | Delaware, Oklahoma, US | |
1300602 | 1300602 | 2022-02-17 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-18 04:21:04 | Delaware, Oklahoma, US | |
3822988 | 3822988 | 2022-02-16 | US | Oklahoma | Delaware | 40041 | 10869 | 187 | 0 | 36.40823634 | -94.80325046 | 2022-02-17 04:20:56 | Delaware, Oklahoma, US | |
2474806 | 2474806 | 2022-02-03 | US | Georgia | Murray | 13213 | 10869 | 160 | 0 | 34.78897608 | -84.74993177 | 2022-02-04 04:21:10 | Murray, Georgia, US | |
1321783 | 1321783 | 2022-01-26 | US | Wisconsin | Oconto | 55083 | 10869 | 94 | 0 | 45.02715345 | -88.26807503 | 2022-01-27 04:21:19 | Oconto, Wisconsin, US | |
1964131 | 1964131 | 2022-01-20 | US | Wisconsin | Polk | 55095 | 10869 | 112 | 0 | 45.46130348 | -92.44182875 | 2022-01-21 04:21:09 | Polk, Wisconsin, US | |
3520977 | 3520977 | 2022-01-02 | US | Louisiana | Vermilion | 22113 | 10869 | 195 | 0 | 29.83517605 | -92.30292538 | 2022-01-03 02:22:25 | Vermilion, Louisiana, US | |
2169107 | 2169107 | 2022-01-01 | US | Louisiana | Vermilion | 22113 | 10869 | 195 | 0 | 29.83517605 | -92.30292538 | 2022-01-02 04:20:52 | Vermilion, Louisiana, US | |
2778538 | 2778538 | 2021-12-31 | US | Louisiana | Vermilion | 22113 | 10869 | 195 | 0 | 29.83517605 | -92.30292538 | 2022-01-01 04:22:14 | Vermilion, Louisiana, US | |
4000195 | 4000195 | 2021-12-30 | US | Louisiana | Vermilion | 22113 | 10869 | 195 | 0 | 29.83517605 | -92.30292538 | 2021-12-31 04:21:50 | Vermilion, Louisiana, US | |
1667568 | 1667568 | 2021-12-11 | US | Texas | Hunt | 48231 | 10869 | 312 | 0 | 33.12351514 | -96.08551032 | 2021-12-12 04:22:12 | Hunt, Texas, US | |
1079594 | 1079594 | 2021-12-09 | US | Michigan | Montcalm | 26117 | 10869 | 150 | 0 | 43.31082541 | -85.15252824 | 2021-12-10 04:22:28 | Montcalm, Michigan, US | |
552443 | 552443 | 2021-12-08 | US | Michigan | Montcalm | 26117 | 10869 | 150 | 0 | 43.31082541 | -85.15252824 | 2021-12-09 04:22:49 | Montcalm, Michigan, US | |
3290676 | 3290676 | 2021-11-18 | US | Minnesota | Rice | 27131 | 10869 | 137 | 0 | 44.3543376 | -93.29658715 | 2021-11-19 04:21:40 | Rice, Minnesota, US | |
468497 | 468497 | 2021-10-07 | US | Indiana | Floyd | 18043 | 10869 | 214 | 0 | 38.32117957 | -85.90385377 | 2021-10-08 04:21:25 | Floyd, Indiana, US | |
644107 | 644107 | 2021-09-07 | US | New Jersey | Hunterdon | 34019 | 10869 | 180 | 0 | 40.56335249 | -74.91284156 | 2021-09-08 04:21:31 | Hunterdon, New Jersey, US | |
1777650 | 1777650 | 2021-08-30 | US | North Carolina | Caldwell | 37027 | 10869 | 111 | 0 | 35.95204977 | -81.54799522 | 2021-08-31 04:21:46 | Caldwell, North Carolina, US | |
248101 | 248101 | 2021-08-17 | US | South Carolina | Oconee | 45073 | 10869 | 148 | 0 | 34.75225169 | -83.06742317 | 2021-08-18 04:21:35 | Oconee, South Carolina, US | |
1895631 | 1895631 | 2021-06-30 | US | Ohio | Miami | 39109 | 10869 | 227 | 0 | 40.0543329 | -84.22871271 | 2021-07-01 04:21:19 | Miami, Ohio, US | |
1895039 | 1895039 | 2021-06-30 | US | Missouri | Franklin | 29071 | 10869 | 186 | 0 | 38.41127108 | -91.07522826 | 2021-07-01 04:21:19 | Franklin, Missouri, US | |
83759 | 83759 | 2021-05-25 | US | Connecticut | Windham | 9015 | 10869 | 194 | 0 | 41.82972709 | -71.98182316 | 2021-05-26 04:20:35 | Windham, Connecticut, US | |
2390887 | 2390887 | 2021-05-18 | Netherlands | Aruba | 10869 | 105 | 10685 | 79 | 12.5211 | -69.9683 | 2021-05-19 04:20:42 | Aruba, Netherlands | ||
3003387 | 3003387 | 2021-04-06 | Mexico | Colima | 10869 | 1146 | 0 | 9723 | 19.1223 | -104.0072 | 2021-04-07 04:20:53 | Colima, Mexico | ||
1590431 | 1590431 | 2021-02-05 | US | New York | Saratoga | 36091 | 10869 | 127 | 0 | 10742 | 43.10904162 | -73.86653895 | 2021-02-06 05:23:55 | Saratoga, New York, US |
2468387 | 2468387 | 2021-01-22 | US | Maryland | Washington | 24043 | 10869 | 203 | 0 | 10666 | 39.60835778 | -77.82002295 | 2021-01-23 05:22:03 | Washington, Maryland, US |
3104811 | 3104811 | 2021-01-16 | US | Virginia | Norfolk | 51710 | 10869 | 123 | 0 | 10746 | 36.89934014 | -76.26420872 | 2021-01-17 05:22:17 | Norfolk, Virginia, US |
2938418 | 2938418 | 2020-11-28 | US | Texas | Potter | 48375 | 10869 | 176 | 0 | 12184 | 35.40133773 | -101.893964 | 2020-11-29 05:25:55 | Potter, Texas, US |
2380723 | 2380723 | 2020-10-01 | US | Indiana | Lake | 18089 | 10869 | 354 | 0 | 10515 | 41.41874274 | -87.38277575 | 2020-10-02 04:23:51 | Lake, Indiana, US |
2299692 | 2299692 | 2020-08-22 | Russia | Stavropol Krai | 10869 | 212 | 7365 | 3292 | 44.86325770000001 | 43.4406913 | 2020-08-23 04:27:48 | Stavropol Krai, Russia | ||
206377 | 206377 | 2020-08-19 | Netherlands | Noord-Holland | 10869 | 825 | 0 | 10007 | 52.60090600000001 | 4.918688 | 2020-08-20 04:27:43 | Noord-Holland, Netherlands | ||
3045299 | 3045299 | 2020-07-02 | Germany | Hessen | 10869 | 507 | 9952 | 409 | 50.6521 | 9.1624 | 2020-07-03 04:33:54 | Hessen, Germany |
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]);