johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
536 rows where confirmed = 917 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329252 | 329252 | 2022-12-27 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-28 04:21:04 | Rush, Kansas, US | |
219325 | 219325 | 2022-12-26 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-27 04:21:07 | Rush, Kansas, US | |
3223782 | 3223782 | 2022-12-25 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-26 04:21:06 | Rush, Kansas, US | |
1019696 | 1019696 | 2022-12-24 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-25 04:21:04 | Rush, Kansas, US | |
691719 | 691719 | 2022-12-23 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-24 04:21:02 | Rush, Kansas, US | |
2180929 | 2180929 | 2022-12-22 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-23 04:21:04 | Rush, Kansas, US | |
452733 | 452733 | 2022-12-21 | US | Kansas | Rush | 20165 | 917 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-22 04:20:56 | Rush, Kansas, US | |
2954280 | 2954280 | 2022-12-20 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-21 04:21:03 | Marshall, South Dakota, US | |
3176682 | 3176682 | 2022-12-19 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-20 04:21:04 | Marshall, South Dakota, US | |
1631199 | 1631199 | 2022-12-18 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-19 04:21:03 | Marshall, South Dakota, US | |
506578 | 506578 | 2022-12-17 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-18 04:21:03 | Marshall, South Dakota, US | |
3327150 | 3327150 | 2022-12-16 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-17 04:21:04 | Marshall, South Dakota, US | |
545662 | 545662 | 2022-12-15 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-16 04:21:01 | Marshall, South Dakota, US | |
351190 | 351190 | 2022-12-14 | US | South Dakota | Marshall | 46091 | 917 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-15 04:20:58 | Marshall, South Dakota, US | |
719097 | 719097 | 2022-12-04 | US | Colorado | Costilla | 8023 | 917 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-05 04:20:58 | Costilla, Colorado, US | |
2817386 | 2817386 | 2022-12-03 | US | Colorado | Costilla | 8023 | 917 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-04 04:20:56 | Costilla, Colorado, US | |
834242 | 834242 | 2022-12-02 | US | Colorado | Costilla | 8023 | 917 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-03 04:21:02 | Costilla, Colorado, US | |
3462384 | 3462384 | 2022-11-21 | US | New Mexico | Union | 35059 | 917 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-11-22 04:20:47 | Union, New Mexico, US | |
2531780 | 2531780 | 2022-10-06 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-07 04:23:08 | Cavalier, North Dakota, US | |
1813174 | 1813174 | 2022-10-05 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-06 04:21:22 | Cavalier, North Dakota, US | |
133148 | 133148 | 2022-10-04 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-05 04:23:06 | Cavalier, North Dakota, US | |
2688095 | 2688095 | 2022-10-03 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-04 04:22:55 | Cavalier, North Dakota, US | |
2262173 | 2262173 | 2022-10-02 | US | North Dakota | Hettinger | 38041 | 917 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-03 04:23:11 | Hettinger, North Dakota, US | |
2262162 | 2262162 | 2022-10-02 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-03 04:23:11 | Cavalier, North Dakota, US | |
2997699 | 2997699 | 2022-10-01 | US | North Dakota | Hettinger | 38041 | 917 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-02 04:21:23 | Hettinger, North Dakota, US | |
2997688 | 2997688 | 2022-10-01 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-02 04:21:23 | Cavalier, North Dakota, US | |
856025 | 856025 | 2022-09-30 | US | North Dakota | Hettinger | 38041 | 917 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-10-01 04:23:01 | Hettinger, North Dakota, US | |
856014 | 856014 | 2022-09-30 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-10-01 04:23:01 | Cavalier, North Dakota, US | |
2377940 | 2377940 | 2022-09-29 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-30 04:23:09 | Cavalier, North Dakota, US | |
2377823 | 2377823 | 2022-09-29 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-30 04:23:09 | Unassigned, New York, US | |
1562491 | 1562491 | 2022-09-28 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-29 04:22:34 | Cavalier, North Dakota, US | |
1562374 | 1562374 | 2022-09-28 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-29 04:22:34 | Unassigned, New York, US | |
3997034 | 3997034 | 2022-09-27 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-28 04:23:01 | Cavalier, North Dakota, US | |
3996917 | 3996917 | 2022-09-27 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-28 04:23:01 | Unassigned, New York, US | |
2771362 | 2771362 | 2022-09-26 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-27 04:23:01 | Cavalier, North Dakota, US | |
2771245 | 2771245 | 2022-09-26 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-27 04:23:01 | Unassigned, New York, US | |
1979015 | 1979015 | 2022-09-25 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-26 04:20:52 | Cavalier, North Dakota, US | |
2652182 | 2652182 | 2022-09-24 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-25 04:23:31 | Cavalier, North Dakota, US | |
386622 | 386622 | 2022-09-23 | US | North Dakota | Cavalier | 38019 | 917 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-09-24 04:21:40 | Cavalier, North Dakota, US | |
1373049 | 1373049 | 2022-09-21 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-22 04:22:56 | Ellis, Oklahoma, US | |
1372775 | 1372775 | 2022-09-21 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-22 04:22:56 | Unassigned, New York, US | |
2019279 | 2019279 | 2022-09-20 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-21 04:23:22 | Ellis, Oklahoma, US | |
3573152 | 3573152 | 2022-09-19 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-20 04:22:48 | Ellis, Oklahoma, US | |
421891 | 421891 | 2022-09-18 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-19 04:21:49 | Ellis, Oklahoma, US | |
421617 | 421617 | 2022-09-18 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-19 04:21:49 | Unassigned, New York, US | |
3375915 | 3375915 | 2022-09-17 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-18 04:22:50 | Ellis, Oklahoma, US | |
3375641 | 3375641 | 2022-09-17 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-18 04:22:50 | Unassigned, New York, US | |
2358023 | 2358023 | 2022-09-16 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-17 04:20:19 | Ellis, Oklahoma, US | |
2357749 | 2357749 | 2022-09-16 | US | New York | Unassigned | 90036 | 917 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-17 04:20:19 | Unassigned, New York, US | |
3989796 | 3989796 | 2022-09-15 | US | Texas | Mason | 48319 | 917 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-16 04:21:19 | Mason, Texas, US | |
3989180 | 3989180 | 2022-09-15 | US | Oklahoma | Ellis | 40045 | 917 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-09-16 04:21:19 | Ellis, Oklahoma, US | |
1892313 | 1892313 | 2022-09-14 | US | Texas | Mason | 48319 | 917 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-15 04:21:02 | Mason, Texas, US | |
375368 | 375368 | 2022-09-13 | US | Texas | Mason | 48319 | 917 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-14 04:20:44 | Mason, Texas, US | |
2397970 | 2397970 | 2022-09-12 | US | Texas | Mason | 48319 | 917 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-13 04:20:57 | Mason, Texas, US | |
1163374 | 1163374 | 2022-08-18 | US | New Mexico | Mora | 35033 | 917 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-08-19 04:20:54 | Mora, New Mexico, US | |
3952698 | 3952698 | 2022-08-17 | US | New Mexico | Mora | 35033 | 917 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-08-18 04:21:11 | Mora, New Mexico, US | |
1098722 | 1098722 | 2022-08-03 | US | Colorado | Baca | 8009 | 917 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-08-04 04:20:58 | Baca, Colorado, US | |
1408247 | 1408247 | 2022-08-02 | US | Texas | Reagan | 48383 | 917 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-03 04:20:59 | Reagan, Texas, US | |
3620285 | 3620285 | 2022-08-01 | US | Texas | Reagan | 48383 | 917 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-08-02 04:20:53 | Reagan, Texas, US | |
3897979 | 3897979 | 2022-05-19 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-20 04:20:57 | Musselshell, Montana, US | |
1186763 | 1186763 | 2022-05-18 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-19 04:20:54 | Musselshell, Montana, US | |
3584660 | 3584660 | 2022-05-17 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-18 04:20:50 | Musselshell, Montana, US | |
3583563 | 3583563 | 2022-05-17 | US | Idaho | Bear Lake | 16007 | 917 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-18 04:20:50 | Bear Lake, Idaho, US | |
1505617 | 1505617 | 2022-05-16 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-17 04:20:59 | Musselshell, Montana, US | |
1504520 | 1504520 | 2022-05-16 | US | Idaho | Bear Lake | 16007 | 917 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-17 04:20:59 | Bear Lake, Idaho, US | |
2085976 | 2085976 | 2022-05-15 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-16 04:20:47 | Musselshell, Montana, US | |
2084879 | 2084879 | 2022-05-15 | US | Idaho | Bear Lake | 16007 | 917 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-16 04:20:47 | Bear Lake, Idaho, US | |
3356686 | 3356686 | 2022-05-14 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-15 04:20:53 | Musselshell, Montana, US | |
3355589 | 3355589 | 2022-05-14 | US | Idaho | Bear Lake | 16007 | 917 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-15 04:20:53 | Bear Lake, Idaho, US | |
660331 | 660331 | 2022-05-13 | US | Montana | Musselshell | 30065 | 917 | 31 | 0 | 46.49684637 | -108.39498 | 2022-05-14 04:20:48 | Musselshell, Montana, US | |
659234 | 659234 | 2022-05-13 | US | Idaho | Bear Lake | 16007 | 917 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-05-14 04:20:48 | Bear Lake, Idaho, US | |
1572576 | 1572576 | 2022-05-03 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-05-04 04:20:59 | Unassigned, Alaska, US | |
463836 | 463836 | 2022-05-02 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-05-03 04:21:00 | Unassigned, Alaska, US | |
3916475 | 3916475 | 2022-05-01 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-05-02 04:21:10 | Unassigned, Alaska, US | |
2841279 | 2841279 | 2022-04-30 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-05-01 04:20:57 | Unassigned, Alaska, US | |
1157592 | 1157592 | 2022-04-29 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-30 04:21:05 | Unassigned, Alaska, US | |
1696774 | 1696774 | 2022-04-28 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-29 04:20:59 | Unassigned, Alaska, US | |
3852257 | 3852257 | 2022-04-27 | US | Alaska | Unassigned | 90002 | 917 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-28 04:20:47 | Unassigned, Alaska, US | |
575301 | 575301 | 2022-02-25 | US | Arkansas | Calhoun | 5013 | 917 | 9 | 0 | 33.55598792 | -92.49974403 | 2022-02-26 04:21:12 | Calhoun, Arkansas, US | |
2448531 | 2448531 | 2022-02-22 | US | Minnesota | Red Lake | 27125 | 917 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-23 04:21:09 | Red Lake, Minnesota, US | |
3719944 | 3719944 | 2022-02-21 | US | Minnesota | Red Lake | 27125 | 917 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-22 04:21:01 | Red Lake, Minnesota, US | |
3913778 | 3913778 | 2022-02-20 | US | Minnesota | Red Lake | 27125 | 917 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-21 04:21:05 | Red Lake, Minnesota, US | |
3877336 | 3877336 | 2022-02-19 | US | Minnesota | Red Lake | 27125 | 917 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-20 04:21:00 | Red Lake, Minnesota, US | |
3857592 | 3857592 | 2022-02-18 | US | Minnesota | Red Lake | 27125 | 917 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-19 04:21:11 | Red Lake, Minnesota, US | |
1299811 | 1299811 | 2022-02-17 | US | Minnesota | Red Lake | 27125 | 917 | 12 | 0 | 47.87197525 | -96.09561104 | 2022-02-18 04:21:04 | Red Lake, Minnesota, US | |
3673411 | 3673411 | 2022-02-15 | US | Minnesota | Red Lake | 27125 | 917 | 11 | 0 | 47.87197525 | -96.09561104 | 2022-02-16 04:21:10 | Red Lake, Minnesota, US | |
186867 | 186867 | 2022-02-13 | US | Georgia | Echols | 13101 | 917 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-02-14 04:20:51 | Echols, Georgia, US | |
316713 | 316713 | 2022-02-12 | US | Georgia | Echols | 13101 | 917 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-02-13 04:21:00 | Echols, Georgia, US | |
234039 | 234039 | 2022-02-11 | US | Georgia | Echols | 13101 | 917 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-02-12 04:21:06 | Echols, Georgia, US | |
1364499 | 1364499 | 2022-02-08 | US | Nevada | Mineral | 32021 | 917 | 15 | 0 | 38.53841696 | -118.4344506 | 2022-02-09 04:21:04 | Mineral, Nevada, US | |
980489 | 980489 | 2022-02-01 | US | Louisiana | Tensas | 22107 | 917 | 10 | 0 | 32.00760749 | -91.32915234 | 2022-02-02 04:21:09 | Tensas, Louisiana, US | |
2661115 | 2661115 | 2022-01-31 | US | Virginia | Covington | 51580 | 917 | 21 | 0 | 37.7824656 | -79.98631446 | 2022-02-01 04:21:11 | Covington, Virginia, US | |
2659175 | 2659175 | 2022-01-31 | US | Kentucky | Carlisle | 21039 | 917 | 16 | 0 | 36.85372876 | -88.96692220000001 | 2022-02-01 04:21:11 | Carlisle, Kentucky, US | |
1230813 | 1230813 | 2022-01-24 | US | Texas | Presidio | 48377 | 917 | 32 | 0 | 29.99954402 | -104.24080790000001 | 2022-01-25 04:21:05 | Presidio, Texas, US | |
1229344 | 1229344 | 2022-01-24 | US | Minnesota | Kittson | 27069 | 917 | 26 | 0 | 48.77754106 | -96.78317184 | 2022-01-25 04:21:05 | Kittson, Minnesota, US | |
3465123 | 3465123 | 2022-01-18 | US | Idaho | Lewis | 16061 | 917 | 23 | 0 | 46.23315327 | -116.434146 | 2022-01-19 04:21:23 | Lewis, Idaho, US | |
3464799 | 3464799 | 2022-01-18 | US | Colorado | Gilpin | 8047 | 917 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-01-19 04:21:23 | Gilpin, Colorado, US | |
3688849 | 3688849 | 2022-01-13 | US | Kentucky | Ballard | 21007 | 917 | 26 | 0 | 37.05842757 | -88.99427697 | 2022-01-14 04:21:54 | Ballard, Kentucky, US | |
3688378 | 3688378 | 2022-01-13 | US | Georgia | Warren | 13301 | 917 | 26 | 0 | 33.41146451 | -82.67795848 | 2022-01-14 04:21:54 | Warren, Georgia, US | |
1117197 | 1117197 | 2022-01-11 | US | Wyoming | Hot Springs | 56017 | 917 | 12 | 0 | 43.71930657 | -108.44231740000001 | 2022-01-12 04:21:44 | Hot Springs, Wyoming, 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]);