johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
517 rows where confirmed = 989 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019779 | 2019779 | 2022-09-20 | US | Texas | Coke | 48081 | 989 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-09-21 04:23:22 | Coke, Texas, US | |
3573652 | 3573652 | 2022-09-19 | US | Texas | Coke | 48081 | 989 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-09-20 04:22:48 | Coke, Texas, US | |
1252999 | 1252999 | 2022-08-23 | US | New York | Hamilton | 36041 | 989 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-08-24 04:20:46 | Hamilton, New York, US | |
1488886 | 1488886 | 2022-07-26 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-27 04:21:04 | Haskell, Kansas, US | |
2595332 | 2595332 | 2022-07-25 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-26 04:20:58 | Haskell, Kansas, US | |
897447 | 897447 | 2022-07-24 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-25 04:20:51 | Haskell, Kansas, US | |
92441 | 92441 | 2022-07-23 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-24 04:20:47 | Haskell, Kansas, US | |
901463 | 901463 | 2022-07-22 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-23 04:20:53 | Haskell, Kansas, US | |
671599 | 671599 | 2022-07-21 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-22 04:21:15 | Haskell, Kansas, US | |
1609562 | 1609562 | 2022-07-20 | US | Kansas | Haskell | 20081 | 989 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-21 04:21:10 | Haskell, Kansas, US | |
2789680 | 2789680 | 2022-07-10 | US | Colorado | Ouray | 8091 | 989 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-07-11 04:20:46 | Ouray, Colorado, US | |
142633 | 142633 | 2022-07-09 | US | Colorado | Ouray | 8091 | 989 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-07-10 04:20:54 | Ouray, Colorado, US | |
1417733 | 1417733 | 2022-07-08 | US | Colorado | Ouray | 8091 | 989 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-07-09 04:20:59 | Ouray, Colorado, US | |
2240438 | 2240438 | 2022-06-28 | US | Illinois | Pope | 17151 | 989 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-06-29 04:20:59 | Pope, Illinois, US | |
3348744 | 3348744 | 2022-06-24 | US | Nebraska | Nuckolls | 31129 | 989 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-06-25 04:20:57 | Nuckolls, Nebraska, US | |
1650485 | 1650485 | 2022-06-23 | US | Nebraska | Nuckolls | 31129 | 989 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-06-24 04:20:58 | Nuckolls, Nebraska, US | |
2189720 | 2189720 | 2022-06-22 | US | Nebraska | Nuckolls | 31129 | 989 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-06-23 04:20:55 | Nuckolls, Nebraska, US | |
168151 | 168151 | 2022-06-21 | US | Nebraska | Nuckolls | 31129 | 989 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-06-22 04:20:54 | Nuckolls, Nebraska, US | |
1765434 | 1765434 | 2022-06-20 | US | Nebraska | Nuckolls | 31129 | 989 | 13 | 0 | 40.17637905 | -98.04743961 | 2022-06-21 04:20:56 | Nuckolls, Nebraska, US | |
3594568 | 3594568 | 2022-05-23 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-24 04:20:57 | Tensas, Louisiana, US | |
623420 | 623420 | 2022-05-22 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-26 04:20:50 | Tensas, Louisiana, US | |
1111116 | 1111116 | 2022-05-21 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-22 04:20:52 | Tensas, Louisiana, US | |
1170740 | 1170740 | 2022-05-20 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-21 04:20:58 | Tensas, Louisiana, US | |
3897503 | 3897503 | 2022-05-19 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-20 04:20:57 | Tensas, Louisiana, US | |
1186289 | 1186289 | 2022-05-18 | US | Louisiana | Unassigned | 90022 | 989 | 0 | 0 | 32.83121059 | 0.0 | 2022-05-19 04:20:54 | Unassigned, Louisiana, US | |
1186287 | 1186287 | 2022-05-18 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-19 04:20:54 | Tensas, Louisiana, US | |
3584184 | 3584184 | 2022-05-17 | US | Louisiana | Tensas | 22107 | 989 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-05-18 04:20:50 | Tensas, Louisiana, US | |
661440 | 661440 | 2022-05-13 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-14 04:20:48 | Hudspeth, Texas, US | |
2536523 | 2536523 | 2022-05-12 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-13 04:20:51 | Hudspeth, Texas, US | |
2535317 | 2535317 | 2022-05-12 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-13 04:20:51 | Knox, Missouri, US | |
3447969 | 3447969 | 2022-05-11 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-12 04:20:54 | Hudspeth, Texas, US | |
3446763 | 3446763 | 2022-05-11 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-12 04:20:54 | Knox, Missouri, US | |
3538586 | 3538586 | 2022-05-10 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-11 04:20:48 | Hudspeth, Texas, US | |
3537380 | 3537380 | 2022-05-10 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-11 04:20:48 | Knox, Missouri, US | |
225121 | 225121 | 2022-05-09 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-10 04:20:50 | Hudspeth, Texas, US | |
224396 | 224396 | 2022-05-09 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-10 04:20:50 | Foster, North Dakota, US | |
223915 | 223915 | 2022-05-09 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-10 04:20:50 | Knox, Missouri, US | |
2334506 | 2334506 | 2022-05-08 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-09 04:20:54 | Hudspeth, Texas, US | |
2333781 | 2333781 | 2022-05-08 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-09 04:20:54 | Foster, North Dakota, US | |
2333300 | 2333300 | 2022-05-08 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-09 04:20:54 | Knox, Missouri, US | |
363468 | 363468 | 2022-05-07 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-08 04:20:49 | Hudspeth, Texas, US | |
362743 | 362743 | 2022-05-07 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-08 04:20:49 | Foster, North Dakota, US | |
362262 | 362262 | 2022-05-07 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-08 04:20:49 | Knox, Missouri, US | |
1400819 | 1400819 | 2022-05-06 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-07 04:21:09 | Hudspeth, Texas, US | |
1400094 | 1400094 | 2022-05-06 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-07 04:21:09 | Foster, North Dakota, US | |
1399613 | 1399613 | 2022-05-06 | US | Missouri | Knox | 29103 | 989 | 14 | 0 | 40.12699751 | -92.14780832 | 2022-05-07 04:21:09 | Knox, Missouri, US | |
2601174 | 2601174 | 2022-05-05 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-06 04:21:00 | Hudspeth, Texas, US | |
2600449 | 2600449 | 2022-05-05 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-06 04:21:00 | Foster, North Dakota, US | |
3268623 | 3268623 | 2022-05-04 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-05 04:20:55 | Hudspeth, Texas, US | |
3267898 | 3267898 | 2022-05-04 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-05 04:20:55 | Foster, North Dakota, US | |
1575262 | 1575262 | 2022-05-03 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-04 04:20:59 | Hudspeth, Texas, US | |
1574537 | 1574537 | 2022-05-03 | US | North Dakota | Foster | 38031 | 989 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-05-04 04:20:59 | Foster, North Dakota, US | |
466522 | 466522 | 2022-05-02 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-03 04:21:00 | Hudspeth, Texas, US | |
3919161 | 3919161 | 2022-05-01 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-02 04:21:10 | Hudspeth, Texas, US | |
2843965 | 2843965 | 2022-04-30 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-01 04:20:57 | Hudspeth, Texas, US | |
1160278 | 1160278 | 2022-04-29 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-30 04:21:05 | Hudspeth, Texas, US | |
1699460 | 1699460 | 2022-04-28 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-29 04:20:59 | Hudspeth, Texas, US | |
3854943 | 3854943 | 2022-04-27 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-28 04:20:47 | Hudspeth, Texas, US | |
1329373 | 1329373 | 2022-04-26 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-27 04:20:52 | Hudspeth, Texas, US | |
3725327 | 3725327 | 2022-04-25 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-26 04:20:51 | Hudspeth, Texas, US | |
2031895 | 2031895 | 2022-04-24 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-25 04:20:56 | Hudspeth, Texas, US | |
749470 | 749470 | 2022-04-23 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-24 04:20:56 | Hudspeth, Texas, US | |
3439955 | 3439955 | 2022-04-22 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-23 04:20:50 | Hudspeth, Texas, US | |
2895540 | 2895540 | 2022-04-21 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-22 04:20:45 | Hudspeth, Texas, US | |
2310412 | 2310412 | 2022-04-20 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-21 04:20:46 | Hudspeth, Texas, US | |
2254551 | 2254551 | 2022-04-19 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-20 04:20:45 | Hudspeth, Texas, US | |
1849101 | 1849101 | 2022-04-18 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-19 04:21:00 | Hudspeth, Texas, US | |
3420045 | 3420045 | 2022-04-17 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-18 04:21:12 | Hudspeth, Texas, US | |
306994 | 306994 | 2022-04-16 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-17 04:20:59 | Hudspeth, Texas, US | |
2672939 | 2672939 | 2022-04-15 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-16 04:20:48 | Hudspeth, Texas, US | |
1226724 | 1226724 | 2022-04-14 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-15 04:20:57 | Hudspeth, Texas, US | |
2445882 | 2445882 | 2022-04-13 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-13 23:21:06 | Hudspeth, Texas, US | |
1951639 | 1951639 | 2022-04-12 | US | Texas | Hudspeth | 48229 | 989 | 18 | 0 | 31.45628381 | -105.388178 | 2022-04-13 04:21:03 | Hudspeth, Texas, US | |
2478534 | 2478534 | 2022-03-30 | US | California | Modoc | 6049 | 989 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-03-31 04:20:56 | Modoc, California, US | |
3628580 | 3628580 | 2022-03-13 | US | Colorado | Gilpin | 8047 | 989 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-03-14 04:20:46 | Gilpin, Colorado, US | |
953621 | 953621 | 2022-03-12 | US | Puerto Rico | Las Marias | 72083 | 989 | 0 | 0 | 18.23679 | -66.98362 | 2022-03-13 04:20:49 | Las Marias, Puerto Rico, US | |
951488 | 951488 | 2022-03-12 | US | Colorado | Gilpin | 8047 | 989 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-03-13 04:20:49 | Gilpin, Colorado, US | |
359082 | 359082 | 2022-03-11 | US | Puerto Rico | Las Marias | 72083 | 989 | 0 | 0 | 18.23679 | -66.98362 | 2022-03-12 04:20:50 | Las Marias, Puerto Rico, US | |
356949 | 356949 | 2022-03-11 | US | Colorado | Gilpin | 8047 | 989 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-03-12 04:20:50 | Gilpin, Colorado, US | |
2202396 | 2202396 | 2022-03-06 | US | Puerto Rico | Las Marias | 72083 | 989 | 0 | 0 | 18.23679 | -66.98362 | 2022-03-07 04:20:47 | Las Marias, Puerto Rico, US | |
2094853 | 2094853 | 2022-03-05 | US | Puerto Rico | Las Marias | 72083 | 989 | 0 | 0 | 18.23679 | -66.98362 | 2022-03-06 04:20:49 | Las Marias, Puerto Rico, US | |
2668553 | 2668553 | 2022-03-04 | US | Puerto Rico | Las Marias | 72083 | 989 | 0 | 0 | 18.23679 | -66.98362 | 2022-03-05 04:21:10 | Las Marias, Puerto Rico, US | |
1646770 | 1646770 | 2022-03-03 | US | North Dakota | LaMoure | 38045 | 989 | 19 | 0 | 46.45681054 | -98.53542355 | 2022-03-04 04:21:09 | LaMoure, North Dakota, US | |
2527773 | 2527773 | 2022-03-02 | US | North Dakota | LaMoure | 38045 | 989 | 19 | 0 | 46.45681054 | -98.53542355 | 2022-03-03 04:21:01 | LaMoure, North Dakota, US | |
1514733 | 1514733 | 2022-02-24 | US | Virginia | Covington | 51580 | 989 | 23 | 0 | 37.7824656 | -79.98631446 | 2022-02-25 04:21:11 | Covington, Virginia, US | |
3822876 | 3822876 | 2022-02-16 | US | North Dakota | Wells | 38103 | 989 | 11 | 0 | 47.58614526 | -99.65904998 | 2022-02-17 04:20:56 | Wells, North Dakota, US | |
3674977 | 3674977 | 2022-02-15 | US | Virginia | Covington | 51580 | 989 | 23 | 0 | 37.7824656 | -79.98631446 | 2022-02-16 04:21:10 | Covington, Virginia, US | |
461290 | 461290 | 2022-02-02 | US | Missouri | Holt | 29087 | 989 | 25 | 0 | 40.09799248 | -95.21638879999999 | 2022-02-03 04:21:21 | Holt, Missouri, US | |
981145 | 981145 | 2022-02-01 | US | New Mexico | Guadalupe | 35019 | 989 | 16 | 0 | 34.86319296 | -104.790669 | 2022-02-02 04:21:09 | Guadalupe, New Mexico, US | |
3303624 | 3303624 | 2022-01-30 | US | Virginia | Surry | 51181 | 989 | 14 | 0 | 37.11781893 | -76.88450012 | 2022-01-31 04:21:09 | Surry, Virginia, US | |
3065415 | 3065415 | 2022-01-29 | US | Virginia | Surry | 51181 | 989 | 14 | 0 | 37.11781893 | -76.88450012 | 2022-01-30 04:21:26 | Surry, Virginia, US | |
3813349 | 3813349 | 2022-01-28 | US | Virginia | Surry | 51181 | 989 | 14 | 0 | 37.11781893 | -76.88450012 | 2022-01-29 04:21:10 | Surry, Virginia, US | |
2053120 | 2053120 | 2022-01-25 | US | Iowa | Ringgold | 19159 | 989 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-26 04:21:07 | Ringgold, Iowa, US | |
2051696 | 2051696 | 2022-01-25 | China | Xinjiang | 989 | 3 | 0 | 41.1129 | 85.2401 | 2022-01-26 04:21:07 | Xinjiang, China | |||
1228851 | 1228851 | 2022-01-24 | US | Iowa | Ringgold | 19159 | 989 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-25 04:21:05 | Ringgold, Iowa, US | |
1142150 | 1142150 | 2022-01-23 | US | Iowa | Ringgold | 19159 | 989 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-24 04:21:12 | Ringgold, Iowa, US | |
2836093 | 2836093 | 2022-01-22 | US | Texas | Yoakum | 48501 | 989 | 37 | 0 | 33.17320212 | -102.82764329999999 | 2022-01-23 04:21:13 | Yoakum, Texas, US | |
2834068 | 2834068 | 2022-01-22 | US | Iowa | Ringgold | 19159 | 989 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-23 04:21:13 | Ringgold, Iowa, US | |
3428233 | 3428233 | 2022-01-21 | US | Vermont | Essex | 50009 | 989 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-01-22 04:21:13 | Essex, Vermont, US | |
3426186 | 3426186 | 2022-01-21 | US | Iowa | Ringgold | 19159 | 989 | 31 | 0 | 40.73518949 | -94.24368535 | 2022-01-22 04:21:13 | Ringgold, Iowa, 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]);