daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
438 rows where confirmed = 1107 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-12 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-13 04:21:01 | Sharkey, Mississippi, US | |
2022-12-11 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-12 04:21:01 | Sharkey, Mississippi, US | |
2022-12-10 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-11 04:20:50 | Sharkey, Mississippi, US | |
2022-12-09 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-10 04:21:02 | Sharkey, Mississippi, US | |
2022-12-08 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-09 04:21:05 | Sharkey, Mississippi, US | |
2022-12-07 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-08 04:21:07 | Sharkey, Mississippi, US | |
2022-12-06 | US | Mississippi | Sharkey | 28125 | 1107 | 27 | 0 | 32.88149103 | -90.8159538 | 2022-12-07 04:20:58 | Sharkey, Mississippi, US | |
2022-11-10 | US | North Dakota | Foster | 38031 | 1107 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-11-11 04:21:22 | Foster, North Dakota, US | |
2022-11-09 | US | North Dakota | Foster | 38031 | 1107 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-11-10 04:21:16 | Foster, North Dakota, US | |
2022-11-08 | US | North Dakota | Foster | 38031 | 1107 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-11-09 04:21:22 | Foster, North Dakota, US | |
2022-09-12 | US | North Dakota | LaMoure | 38045 | 1107 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-09-13 04:20:57 | LaMoure, North Dakota, US | |
2022-09-08 | US | Illinois | Pope | 17151 | 1107 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-09-09 04:21:11 | Pope, Illinois, US | |
2022-09-07 | US | Illinois | Pope | 17151 | 1107 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-09-08 04:21:02 | Pope, Illinois, US | |
2022-09-01 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-09-02 04:21:07 | Putnam, Missouri, US | |
2022-09-01 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-09-02 04:21:07 | Knox, Missouri, US | |
2022-08-31 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-09-01 04:21:03 | Putnam, Missouri, US | |
2022-08-31 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-09-01 04:21:03 | Knox, Missouri, US | |
2022-08-30 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-08-31 04:20:57 | Putnam, Missouri, US | |
2022-08-30 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-08-31 04:20:57 | Knox, Missouri, US | |
2022-08-29 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-08-30 04:21:03 | Putnam, Missouri, US | |
2022-08-29 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-08-30 04:21:03 | Knox, Missouri, US | |
2022-08-29 | US | Arkansas | Calhoun | 5013 | 1107 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-08-30 04:21:03 | Calhoun, Arkansas, US | |
2022-08-28 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-08-29 04:21:06 | Putnam, Missouri, US | |
2022-08-28 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-08-29 04:21:06 | Knox, Missouri, US | |
2022-08-28 | US | Arkansas | Calhoun | 5013 | 1107 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-08-29 04:21:06 | Calhoun, Arkansas, US | |
2022-08-27 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-08-28 04:21:02 | Putnam, Missouri, US | |
2022-08-27 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-08-28 04:21:02 | Knox, Missouri, US | |
2022-08-27 | US | Arkansas | Calhoun | 5013 | 1107 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-08-28 04:21:02 | Calhoun, Arkansas, US | |
2022-08-26 | US | Missouri | Putnam | 29171 | 1107 | 26 | 0 | 40.47942497 | -93.02042674 | 2022-08-27 04:20:57 | Putnam, Missouri, US | |
2022-08-26 | US | Missouri | Knox | 29103 | 1107 | 15 | 0 | 40.12699751 | -92.14780832 | 2022-08-27 04:20:57 | Knox, Missouri, US | |
2022-08-17 | US | North Dakota | Dunn | 38025 | 1107 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-08-18 04:21:11 | Dunn, North Dakota, US | |
2022-08-07 | US | Texas | Hudspeth | 48229 | 1107 | 18 | 0 | 31.45628381 | -105.388178 | 2022-08-08 04:21:08 | Hudspeth, Texas, US | |
2022-08-06 | US | Texas | Hudspeth | 48229 | 1107 | 18 | 0 | 31.45628381 | -105.388178 | 2022-08-07 04:20:54 | Hudspeth, Texas, US | |
2022-08-05 | US | Texas | Hudspeth | 48229 | 1107 | 18 | 0 | 31.45628381 | -105.388178 | 2022-08-06 04:20:56 | Hudspeth, Texas, US | |
2022-08-04 | US | Texas | Hudspeth | 48229 | 1107 | 18 | 0 | 31.45628381 | -105.388178 | 2022-08-05 04:20:52 | Hudspeth, Texas, US | |
2022-07-26 | US | Puerto Rico | Maricao | 72093 | 1107 | 0 | 0 | 18.171795 | -66.942126 | 2022-07-27 04:21:04 | Maricao, Puerto Rico, US | |
2022-07-25 | US | Puerto Rico | Maricao | 72093 | 1107 | 0 | 0 | 18.171795 | -66.942126 | 2022-07-26 04:20:58 | Maricao, Puerto Rico, US | |
2022-07-24 | US | Puerto Rico | Maricao | 72093 | 1107 | 0 | 0 | 18.171795 | -66.942126 | 2022-07-25 04:20:51 | Maricao, Puerto Rico, US | |
2022-07-22 | US | Colorado | Washington | 8121 | 1107 | 29 | 0 | 39.97015535 | -103.202587 | 2022-07-23 04:20:53 | Washington, Colorado, US | |
2022-07-21 | US | Colorado | Washington | 8121 | 1107 | 29 | 0 | 39.97015535 | -103.202587 | 2022-07-22 04:21:15 | Washington, Colorado, US | |
2022-07-18 | US | North Dakota | Pierce | 38069 | 1107 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-07-19 04:20:58 | Pierce, North Dakota, US | |
2022-07-06 | US | Virginia | Rappahannock | 51157 | 1107 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-07-07 04:20:55 | Rappahannock, Virginia, US | |
2022-06-29 | US | Texas | Crockett | 48105 | 1107 | 20 | 0 | 30.72367027 | -101.4134238 | 2022-06-30 04:21:01 | Crockett, Texas, US | |
2022-06-23 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-24 04:20:58 | Holt, Missouri, US | |
2022-06-22 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-23 04:20:55 | Holt, Missouri, US | |
2022-06-21 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-22 04:20:54 | Holt, Missouri, US | |
2022-06-20 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-21 04:20:56 | Holt, Missouri, US | |
2022-06-19 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-20 04:21:01 | Holt, Missouri, US | |
2022-06-18 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-19 04:20:51 | Holt, Missouri, US | |
2022-06-17 | US | Missouri | Holt | 29087 | 1107 | 30 | 0 | 40.09799248 | -95.2163888 | 2022-06-18 04:21:10 | Holt, Missouri, US | |
2022-05-24 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-25 04:20:56 | Lincoln, Idaho, US | |
2022-05-23 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-24 04:20:57 | Lincoln, Idaho, US | |
2022-05-21 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-22 04:20:52 | Lincoln, Idaho, US | |
2022-05-20 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-21 04:20:58 | Lincoln, Idaho, US | |
2022-05-19 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-20 04:20:57 | Lincoln, Idaho, US | |
2022-05-18 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-19 04:20:54 | Lincoln, Idaho, US | |
2022-05-17 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-18 04:20:50 | Lincoln, Idaho, US | |
2022-05-16 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-17 04:20:59 | Lincoln, Idaho, US | |
2022-05-15 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-16 04:20:47 | Lincoln, Idaho, US | |
2022-05-14 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-15 04:20:53 | Lincoln, Idaho, US | |
2022-05-13 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-14 04:20:48 | Lincoln, Idaho, US | |
2022-05-12 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-13 04:20:51 | Lincoln, Idaho, US | |
2022-05-11 | US | Virginia | Surry | 51181 | 1107 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-05-12 04:20:54 | Surry, Virginia, US | |
2022-05-11 | US | Idaho | Lincoln | 16063 | 1107 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-05-12 04:20:54 | Lincoln, Idaho, US | |
2022-04-28 | US | New Mexico | Guadalupe | 35019 | 1107 | 17 | 0 | 34.86319296 | -104.790669 | 2022-04-29 04:20:59 | Guadalupe, New Mexico, US | |
2022-04-27 | US | New Mexico | Guadalupe | 35019 | 1107 | 17 | 0 | 34.86319296 | -104.790669 | 2022-04-28 04:20:47 | Guadalupe, New Mexico, US | |
2022-04-26 | US | New Mexico | Guadalupe | 35019 | 1107 | 17 | 0 | 34.86319296 | -104.790669 | 2022-04-27 04:20:52 | Guadalupe, New Mexico, US | |
2022-04-25 | US | New Mexico | Guadalupe | 35019 | 1107 | 17 | 0 | 34.86319296 | -104.790669 | 2022-04-26 04:20:51 | Guadalupe, New Mexico, US | |
2022-03-03 | US | Virginia | Craig | 51045 | 1107 | 15 | 0 | 37.48133648 | -80.21072274 | 2022-03-04 04:21:09 | Craig, Virginia, US | |
2022-03-03 | US | Nebraska | Thayer | 31169 | 1107 | 4 | 0 | 40.17626377 | -97.59504381 | 2022-03-04 04:21:09 | Thayer, Nebraska, US | |
2022-03-02 | US | Virginia | Craig | 51045 | 1107 | 15 | 0 | 37.48133648 | -80.21072274 | 2022-03-03 04:21:01 | Craig, Virginia, US | |
2022-03-02 | US | Vermont | Essex | 50009 | 1107 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-03 04:21:01 | Essex, Vermont, US | |
2022-03-02 | US | Nebraska | Thayer | 31169 | 1107 | 4 | 0 | 40.17626377 | -97.59504381 | 2022-03-03 04:21:01 | Thayer, Nebraska, US | |
2022-03-01 | US | Vermont | Essex | 50009 | 1107 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-02 04:21:07 | Essex, Vermont, US | |
2022-02-28 | US | Vermont | Essex | 50009 | 1107 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-01 04:21:09 | Essex, Vermont, US | |
2022-02-28 | US | Nebraska | Thayer | 31169 | 1107 | 4 | 0 | 40.17626377 | -97.59504381 | 2022-03-01 04:21:09 | Thayer, Nebraska, US | |
2022-02-22 | US | Virginia | King and Queen | 51097 | 1107 | 11 | 0 | 37.71044922 | -76.88689628 | 2022-02-23 04:21:09 | King and Queen, Virginia, US | |
2022-02-10 | US | Montana | Pondera | 30073 | 1107 | 6 | 0 | 48.22773388 | -112.22527029999999 | 2022-02-11 04:21:09 | Pondera, Montana, US | |
2022-02-09 | US | Montana | Pondera | 30073 | 1107 | 6 | 0 | 48.22773388 | -112.22527029999999 | 2022-02-10 04:21:14 | Pondera, Montana, US | |
2022-02-09 | US | Missouri | Reynolds | 29179 | 1107 | 20 | 0 | 37.36085952 | -90.97009925 | 2022-02-10 04:21:14 | Reynolds, Missouri, US | |
2022-02-07 | US | Nebraska | Dixon | 31051 | 1107 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-02-08 04:21:15 | Dixon, Nebraska, US | |
2022-02-06 | US | Illinois | Henderson | 17071 | 1107 | 17 | 0 | 40.81908672 | -90.92491462 | 2022-02-07 04:21:05 | Henderson, Illinois, US | |
2022-02-05 | US | Illinois | Henderson | 17071 | 1107 | 17 | 0 | 40.81908672 | -90.92491462 | 2022-02-06 04:21:00 | Henderson, Illinois, US | |
2022-02-04 | US | Illinois | Henderson | 17071 | 1107 | 17 | 0 | 40.81908672 | -90.92491462 | 2022-02-05 04:21:05 | Henderson, Illinois, US | |
2022-02-03 | US | Texas | Martin | 48317 | 1107 | 25 | 0 | 32.30600051 | -101.9513518 | 2022-02-04 04:21:10 | Martin, Texas, US | |
2022-02-02 | US | Texas | Wheeler | 48483 | 1107 | 16 | 0 | 35.40114335 | -100.26995140000001 | 2022-02-03 04:21:21 | Wheeler, Texas, US | |
2022-02-01 | US | Nebraska | Polk | 31143 | 1107 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-02-02 04:21:09 | Polk, Nebraska, US | |
2022-02-01 | US | Nebraska | Morrill | 31123 | 1107 | 7 | 0 | 41.71711774 | -103.0061405 | 2022-02-02 04:21:09 | Morrill, Nebraska, US | |
2022-01-31 | US | Oregon | Wallowa | 41063 | 1107 | 14 | 0 | 45.57894064 | -117.18353799999998 | 2022-02-01 04:21:11 | Wallowa, Oregon, US | |
2022-01-31 | US | Nebraska | Polk | 31143 | 1107 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-02-01 04:21:11 | Polk, Nebraska, US | |
2022-01-31 | US | Nebraska | Morrill | 31123 | 1107 | 7 | 0 | 41.71711774 | -103.0061405 | 2022-02-01 04:21:11 | Morrill, Nebraska, US | |
2022-01-11 | US | North Dakota | McHenry | 38049 | 1107 | 28 | 0 | 48.23104458 | -100.6324822 | 2022-01-12 04:21:44 | McHenry, North Dakota, US | |
2022-01-06 | US | Texas | Mills | 48333 | 1107 | 28 | 0 | 31.49557106 | -98.59272068 | 2022-01-07 04:22:09 | Mills, Texas, US | |
2022-01-05 | US | Idaho | Caribou | 16029 | 1107 | 23 | 0 | 42.77149116 | -111.5597683 | 2022-01-06 04:22:09 | Caribou, Idaho, US | |
2021-12-29 | US | California | Unassigned | 90006 | 1107 | 0 | 0 | 41.74228275 | 0.0 | 2021-12-30 04:21:25 | Unassigned, California, US | |
2021-12-02 | US | Virginia | Madison | 51113 | 1107 | 23 | 0 | 38.41531222 | -78.28220331 | 2021-12-03 04:23:05 | Madison, Virginia, US | |
2021-11-30 | US | Idaho | Power | 16077 | 1107 | 16 | 0 | 42.69254894 | -112.83957420000002 | 2021-12-01 04:22:29 | Power, Idaho, US | |
2021-11-30 | US | Georgia | Twiggs | 13289 | 1107 | 62 | 0 | 32.67435595 | -83.43078662 | 2021-12-01 04:22:29 | Twiggs, Georgia, US | |
2021-11-29 | US | Georgia | Twiggs | 13289 | 1107 | 62 | 0 | 32.67435595 | -83.43078662 | 2021-11-30 04:22:53 | Twiggs, Georgia, US | |
2021-11-28 | US | Georgia | Twiggs | 13289 | 1107 | 62 | 0 | 32.67435595 | -83.43078662 | 2021-11-29 04:22:30 | Twiggs, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;