johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 10394 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1622499 | 1622499 | 2022-11-22 | US | New York | Allegany | 36003 | 10394 | 163 | 0 | 42.25748406 | -78.02750466 | 2022-11-23 04:21:06 | Allegany, New York, US | |
3598999 | 3598999 | 2022-11-14 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-15 04:21:16 | Pulaski, Missouri, US | |
313857 | 313857 | 2022-11-13 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-14 04:21:09 | Pulaski, Missouri, US | |
65018 | 65018 | 2022-11-12 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-13 04:21:14 | Pulaski, Missouri, US | |
2929180 | 2929180 | 2022-11-11 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-12 04:20:41 | Pulaski, Missouri, US | |
2508016 | 2508016 | 2022-11-10 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-11 04:21:22 | Pulaski, Missouri, US | |
2432891 | 2432891 | 2022-11-09 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-10 04:21:16 | Pulaski, Missouri, US | |
481547 | 481547 | 2022-11-08 | US | Missouri | Pulaski | 29169 | 10394 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-11-09 04:21:22 | Pulaski, Missouri, US | |
3100399 | 3100399 | 2022-10-09 | US | Tennessee | Henderson | 47077 | 10394 | 173 | 0 | 35.65581134 | -88.38600175 | 2022-10-10 04:22:32 | Henderson, Tennessee, US | |
2772389 | 2772389 | 2022-09-26 | US | Virginia | Warren | 51187 | 10394 | 165 | 0 | 38.90847745 | -78.20280433 | 2022-09-27 04:23:01 | Warren, Virginia, US | |
1943246 | 1943246 | 2022-08-06 | US | Puerto Rico | Moca | 72099 | 10394 | 0 | 0 | 18.377805 | -67.080952 | 2022-08-07 04:20:54 | Moca, Puerto Rico, US | |
2009614 | 2009614 | 2022-08-04 | US | Idaho | Bingham | 16011 | 10394 | 163 | 0 | 43.2167288 | -112.3978437 | 2022-08-05 04:20:52 | Bingham, Idaho, US | |
1099041 | 1099041 | 2022-08-03 | US | Idaho | Bingham | 16011 | 10394 | 163 | 0 | 43.2167288 | -112.3978437 | 2022-08-04 04:20:58 | Bingham, Idaho, US | |
3538706 | 3538706 | 2022-05-10 | US | Texas | Van Zandt | 48467 | 10394 | 280 | 0 | 32.56483801 | -95.83766469 | 2022-05-11 04:20:48 | Van Zandt, Texas, US | |
2600811 | 2600811 | 2022-05-05 | US | Puerto Rico | Mayaguez | 72097 | 10394 | 0 | 0 | 18.2013 | -67.1452 | 2022-05-06 04:21:00 | Mayaguez, Puerto Rico, US | |
3024560 | 3024560 | 2022-03-23 | US | North Carolina | Alexander | 37003 | 10394 | 133 | 0 | 35.922379600000006 | -81.17751948 | 2022-03-24 04:20:43 | Alexander, North Carolina, US | |
920725 | 920725 | 2022-03-08 | US | Illinois | Randolph | 17157 | 10394 | 121 | 0 | 38.05095369 | -89.82512254 | 2022-03-09 04:20:59 | Randolph, Illinois, US | |
2527107 | 2527107 | 2022-03-02 | US | Minnesota | McLeod | 27085 | 10394 | 105 | 0 | 44.82367677 | -94.27287017 | 2022-03-03 04:21:01 | McLeod, Minnesota, US | |
2526406 | 2526406 | 2022-03-02 | US | Illinois | Randolph | 17157 | 10394 | 121 | 0 | 38.05095369 | -89.82512254 | 2022-03-03 04:21:01 | Randolph, Illinois, US | |
3673187 | 3673187 | 2022-02-15 | US | Louisiana | St. John the Baptist | 22095 | 10394 | 180 | 0 | 30.12597499 | -90.4753503 | 2022-02-16 04:21:10 | St. John the Baptist, Louisiana, US | |
3229456 | 3229456 | 2022-01-19 | US | Tennessee | Warren | 47177 | 10394 | 153 | 0 | 35.672829899999996 | -85.77969117 | 2022-01-20 04:21:07 | Warren, Tennessee, US | |
3401379 | 3401379 | 2021-11-30 | India | Lakshadweep | 10394 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-12-01 04:22:29 | Lakshadweep, India | |||
149922 | 149922 | 2021-11-29 | India | Lakshadweep | 10394 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-30 04:22:53 | Lakshadweep, India | |||
1231568 | 1231568 | 2021-11-28 | India | Lakshadweep | 10394 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-29 04:22:30 | Lakshadweep, India | |||
1358275 | 1358275 | 2021-11-27 | India | Lakshadweep | 10394 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-28 04:22:43 | Lakshadweep, India | |||
758266 | 758266 | 2021-11-26 | India | Lakshadweep | 10394 | 51 | 0 | 13.699997199999999 | 72.18333259999999 | 2021-11-27 04:22:45 | Lakshadweep, India | |||
2846568 | 2846568 | 2021-11-10 | US | Minnesota | Crow Wing | 27035 | 10394 | 118 | 0 | 46.48096553 | -94.06755609 | 2021-11-11 04:21:45 | Crow Wing, Minnesota, US | |
3639698 | 3639698 | 2021-11-08 | Pakistan | Gilgit-Baltistan | 10394 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-09 04:21:36 | Gilgit-Baltistan, Pakistan | |||
2000806 | 2000806 | 2021-11-07 | Pakistan | Gilgit-Baltistan | 10394 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-08 04:21:43 | Gilgit-Baltistan, Pakistan | |||
495797 | 495797 | 2021-11-06 | Pakistan | Gilgit-Baltistan | 10394 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-07 04:21:53 | Gilgit-Baltistan, Pakistan | |||
536444 | 536444 | 2021-10-27 | US | Minnesota | Clay | 27027 | 10394 | 99 | 0 | 46.89289518 | -96.48761922 | 2021-10-28 04:22:08 | Clay, Minnesota, US | |
601271 | 601271 | 2021-10-19 | US | Wisconsin | Wood | 55141 | 10394 | 135 | 0 | 44.45537896 | -90.04158336 | 2021-10-20 04:21:00 | Wood, Wisconsin, US | |
2774539 | 2774539 | 2021-09-30 | US | Maine | Penobscot | 23019 | 10394 | 141 | 0 | 45.40194593 | -68.65020455 | 2021-10-01 04:21:35 | Penobscot, Maine, US | |
604200 | 604200 | 2021-09-23 | US | Ohio | Scioto | 39145 | 10394 | 150 | 0 | 38.80270163 | -82.98907345 | 2021-09-24 04:21:44 | Scioto, Ohio, US | |
1887347 | 1887347 | 2021-09-12 | US | North Carolina | Orange | 37135 | 10394 | 102 | 0 | 36.06092947 | -79.12167935 | 2021-09-13 04:21:15 | Orange, North Carolina, US | |
3808250 | 3808250 | 2021-09-11 | US | North Carolina | Orange | 37135 | 10394 | 102 | 0 | 36.06092947 | -79.12167935 | 2021-09-12 04:21:13 | Orange, North Carolina, US | |
3451190 | 3451190 | 2021-09-10 | US | North Carolina | Orange | 37135 | 10394 | 102 | 0 | 36.06092947 | -79.12167935 | 2021-09-11 04:21:30 | Orange, North Carolina, US | |
178249 | 178249 | 2021-09-02 | Russia | Magadan Oblast | 10394 | 228 | 0 | 62.48858785 | 153.9903764 | 2021-09-03 04:21:20 | Magadan Oblast, Russia | |||
2795717 | 2795717 | 2021-08-28 | US | Pennsylvania | Mercer | 42085 | 10394 | 272 | 0 | 41.30248872 | -80.25816981 | 2021-08-29 04:21:14 | Mercer, Pennsylvania, US | |
3387680 | 3387680 | 2021-07-29 | US | North Carolina | Burke | 37023 | 10394 | 164 | 0 | 35.74989637 | -81.70755735 | 2021-07-30 04:21:34 | Burke, North Carolina, US | |
832316 | 832316 | 2021-07-09 | US | Puerto Rico | Bayamon | 72021 | 10394 | 0 | 0 | 18.34946 | -66.168435 | 2021-07-10 04:21:25 | Bayamon, Puerto Rico, US | |
2074934 | 2074934 | 2021-07-02 | US | Texas | Bastrop | 48021 | 10394 | 101 | 0 | 30.10370699 | -97.31206354 | 2021-07-03 04:21:37 | Bastrop, Texas, US | |
2424775 | 2424775 | 2021-06-23 | US | Missouri | Clay | 29047 | 10394 | 171 | 0 | 39.31132056 | -94.41850862 | 2021-06-24 04:21:55 | Clay, Missouri, US | |
825526 | 825526 | 2021-06-06 | India | Dadra and Nagar Haveli and Daman and Diu | 10394 | 4 | 10261 | 129 | 20.194742 | 73.080901 | 2021-06-07 04:22:51 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3679326 | 3679326 | 2021-05-04 | Malaysia | Kedah | 10394 | 27 | 9451 | 916 | 6.1184 | 100.3685 | 2021-05-05 04:20:43 | Kedah, Malaysia | ||
3005791 | 3005791 | 2021-04-06 | US | Ohio | Miami | 39109 | 10394 | 215 | 0 | 40.0543329 | -84.22871271 | 2021-04-07 04:20:53 | Miami, Ohio, US | |
1617350 | 1617350 | 2021-03-05 | US | Indiana | Monroe | 18105 | 10394 | 164 | 0 | 10230 | 39.16130004 | -86.52414358 | 2021-03-06 04:23:41 | Monroe, Indiana, US |
2367579 | 2367579 | 2021-02-28 | Mexico | Colima | 10394 | 1077 | 0 | 9317 | 19.1223 | -104.0072 | 2021-03-01 05:23:01 | Colima, Mexico | ||
976906 | 976906 | 2021-02-06 | US | Montana | Flathead | 30029 | 10394 | 74 | 0 | 10320 | 48.29575866 | -114.0520569 | 2021-02-07 05:23:00 | Flathead, Montana, US |
238747 | 238747 | 2021-01-18 | US | Louisiana | Livingston | 22063 | 10394 | 143 | 0 | 10251 | 30.44143993 | -90.73061664 | 2021-01-19 05:22:15 | Livingston, Louisiana, US |
930657 | 930657 | 2020-12-21 | US | Tennessee | Montgomery | 47125 | 10394 | 109 | 0 | 10182 | 36.49609412 | -87.38550661 | 2020-12-22 05:22:33 | Montgomery, Tennessee, US |
3149808 | 3149808 | 2020-12-16 | Russia | Kurgan Oblast | 10394 | 132 | 9126 | 1136 | 55.7655302 | 64.5632681 | 2020-12-17 05:28:12 | Kurgan Oblast, Russia | ||
1728676 | 1728676 | 2020-11-08 | Russia | Chuvashia Republic | 10394 | 170 | 8898 | 1326 | 55.4259922 | 47.0849429 | 2020-11-09 05:25:45 | Chuvashia Republic, Russia | ||
1125215 | 1125215 | 2020-09-17 | Ukraine | Ternopil Oblast | 10394 | 122 | 4523 | 5749 | 49.5535 | 25.5948 | 2020-09-18 05:05:00 | Ternopil Oblast, Ukraine | ||
546920 | 546920 | 2020-09-12 | Peru | Puno | 10394 | 1189 | 0 | 9205 | -14.995826999999998 | -69.922726 | 2020-09-13 04:30:52 | Puno, Peru | ||
2173764 | 2173764 | 2020-09-09 | US | New York | Erie | 36029 | 10394 | 681 | 0 | 9713 | 42.76249024 | -78.73063652 | 2020-09-10 04:29:01 | Erie, New York, US |
3563146 | 3563146 | 2020-08-25 | US | California | Ventura | 6111 | 10394 | 99 | 0 | 10287 | 34.44465746 | -119.0910613 | 2020-08-26 04:28:11 | Ventura, California, US |
206163 | 206163 | 2020-08-19 | Germany | Berlin | 10394 | 224 | 9442 | 796 | 52.52 | 13.405 | 2020-08-20 04:27:43 | Berlin, Germany | ||
62167 | 62167 | 2020-07-23 | Italy | Toscana | 10394 | 1131 | 8935 | 328 | 43.76923077 | 11.25588885 | 2020-07-24 05:30:40 | Toscana, Italy |
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]);