johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where confirmed = 21517 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954547 | 2954547 | 2022-12-20 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-21 04:21:03 | Liberty, Texas, US | |
3176949 | 3176949 | 2022-12-19 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-20 04:21:04 | Liberty, Texas, US | |
1631466 | 1631466 | 2022-12-18 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-19 04:21:03 | Liberty, Texas, US | |
506845 | 506845 | 2022-12-17 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-18 04:21:03 | Liberty, Texas, US | |
3327417 | 3327417 | 2022-12-16 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-17 04:21:04 | Liberty, Texas, US | |
545929 | 545929 | 2022-12-15 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-16 04:21:01 | Liberty, Texas, US | |
351457 | 351457 | 2022-12-14 | US | Texas | Liberty | 48291 | 21517 | 411 | 0 | 30.15152688 | -94.81205615 | 2022-12-15 04:20:58 | Liberty, Texas, US | |
2102363 | 2102363 | 2022-11-26 | US | New York | Clinton | 36019 | 21517 | 119 | 0 | 44.74530905 | -73.67875352 | 2022-11-27 04:21:05 | Clinton, New York, US | |
713099 | 713099 | 2022-11-01 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-11-02 04:22:09 | Yamhill, Oregon, US | |
3287548 | 3287548 | 2022-10-31 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-11-01 04:22:36 | Yamhill, Oregon, US | |
322581 | 322581 | 2022-10-30 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-10-31 04:21:36 | Yamhill, Oregon, US | |
914857 | 914857 | 2022-10-29 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-10-30 04:22:14 | Yamhill, Oregon, US | |
1369126 | 1369126 | 2022-10-28 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-10-29 04:21:13 | Yamhill, Oregon, US | |
3040981 | 3040981 | 2022-10-27 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-10-28 04:22:31 | Yamhill, Oregon, US | |
541401 | 541401 | 2022-10-26 | US | Oregon | Yamhill | 41071 | 21517 | 242 | 0 | 45.23330449 | -123.3086963 | 2022-10-27 04:22:01 | Yamhill, Oregon, US | |
2496254 | 2496254 | 2022-08-15 | US | New Mexico | Valencia | 35061 | 21517 | 293 | 0 | 34.71669834 | -106.8103733 | 2022-08-16 04:20:58 | Valencia, New Mexico, US | |
3081549 | 3081549 | 2022-07-04 | US | West Virginia | Harrison | 54033 | 21517 | 258 | 0 | 39.2853852 | -80.37919577 | 2022-07-05 04:20:45 | Harrison, West Virginia, US | |
1770831 | 1770831 | 2022-07-03 | US | West Virginia | Harrison | 54033 | 21517 | 258 | 0 | 39.2853852 | -80.37919577 | 2022-07-04 04:20:54 | Harrison, West Virginia, US | |
3368817 | 3368817 | 2022-07-02 | US | West Virginia | Harrison | 54033 | 21517 | 258 | 0 | 39.2853852 | -80.37919577 | 2022-07-03 04:20:59 | Harrison, West Virginia, US | |
597146 | 597146 | 2022-07-01 | US | West Virginia | Harrison | 54033 | 21517 | 258 | 0 | 39.2853852 | -80.37919577 | 2022-07-02 04:21:16 | Harrison, West Virginia, US | |
3889809 | 3889809 | 2022-06-06 | US | New Mexico | Chaves | 35005 | 21517 | 337 | 0 | 33.36406072 | -104.4665365 | 2022-06-07 04:21:08 | Chaves, New Mexico, US | |
1471089 | 1471089 | 2022-03-24 | US | Tennessee | Robertson | 47147 | 21517 | 295 | 0 | 36.52454807 | -86.87346725 | 2022-03-25 04:20:46 | Robertson, Tennessee, US | |
318831 | 318831 | 2022-02-12 | US | Tennessee | Anderson | 47001 | 21517 | 301 | 0 | 36.12684348 | -84.19965764 | 2022-02-13 04:21:00 | Anderson, Tennessee, US | |
1363248 | 1363248 | 2022-02-08 | US | Georgia | Walton | 13297 | 21517 | 392 | 0 | 33.78017694 | -83.73552314 | 2022-02-09 04:21:04 | Walton, Georgia, US | |
4822 | 4822 | 2021-10-28 | US | Arkansas | Craighead | 5031 | 21517 | 244 | 0 | 35.83018283 | -90.63235729 | 2021-10-29 04:22:03 | Craighead, Arkansas, US | |
493323 | 493323 | 2021-10-14 | US | Michigan | St. Clair | 26147 | 21517 | 503 | 0 | 42.92655373 | -82.67937954 | 2021-10-15 04:21:26 | St. Clair, Michigan, US | |
635611 | 635611 | 2021-10-13 | US | Michigan | St. Clair | 26147 | 21517 | 503 | 0 | 42.92655373 | -82.67937954 | 2021-10-14 04:21:29 | St. Clair, Michigan, US | |
2811939 | 2811939 | 2021-09-16 | US | Texas | Parker | 48367 | 21517 | 239 | 0 | 32.77757172 | -97.80500621 | 2021-09-17 04:21:46 | Parker, Texas, US | |
3219264 | 3219264 | 2021-07-26 | US | Illinois | Champaign | 17019 | 21517 | 158 | 0 | 40.13919438 | -88.20046615 | 2021-07-27 04:21:18 | Champaign, Illinois, US | |
702964 | 702964 | 2021-03-16 | US | California | Placer | 6061 | 21517 | 240 | 0 | 39.06167234 | -120.7240569 | 2021-03-17 05:25:07 | Placer, California, US | |
790602 | 790602 | 2021-02-04 | Russia | Lipetsk Oblast | 21517 | 381 | 17563 | 3573 | 52.6935178 | 39.1122664 | 2021-02-05 05:22:38 | Lipetsk Oblast, Russia | ||
2689731 | 2689731 | 2020-10-08 | Jordan | 21517 | 144 | 5777 | 15596 | 31.24 | 36.51 | 2020-10-09 04:23:59 | Jordan | |||
3791499 | 3791499 | 2020-08-05 | US | North Carolina | Mecklenburg | 37119 | 21517 | 222 | 0 | 21295 | 35.24469268 | -80.8317671 | 2020-08-06 04:35:02 | Mecklenburg, North Carolina, 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]);