johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
295 rows where confirmed = 2723 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 276
- China 4
- Japan 2
- Netherlands 2
- New Zealand 2
- Bahrain 1
- Colombia 1
- France 1
- Germany 1
- Liechtenstein 1
- Malaysia 1
- Mongolia 1
- San Marino 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755890 | 2755890 | 2022-12-29 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-30 04:21:04 | Perry, Tennessee, US | |
1076896 | 1076896 | 2022-12-28 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-29 04:21:01 | Perry, Tennessee, US | |
330893 | 330893 | 2022-12-27 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-28 04:21:04 | Perry, Tennessee, US | |
220966 | 220966 | 2022-12-26 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-27 04:21:07 | Perry, Tennessee, US | |
3225423 | 3225423 | 2022-12-25 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-26 04:21:06 | Perry, Tennessee, US | |
1021337 | 1021337 | 2022-12-24 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-25 04:21:04 | Perry, Tennessee, US | |
693360 | 693360 | 2022-12-23 | US | Tennessee | Perry | 47135 | 2723 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-24 04:21:02 | Perry, Tennessee, US | |
1985443 | 1985443 | 2022-12-07 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-08 04:21:07 | Dooly, Georgia, US | |
3714966 | 3714966 | 2022-12-06 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-07 04:20:58 | Dooly, Georgia, US | |
2415671 | 2415671 | 2022-12-05 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-06 04:21:03 | Dooly, Georgia, US | |
719279 | 719279 | 2022-12-04 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-05 04:20:58 | Dooly, Georgia, US | |
2817568 | 2817568 | 2022-12-03 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-04 04:20:56 | Dooly, Georgia, US | |
834424 | 834424 | 2022-12-02 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-03 04:21:02 | Dooly, Georgia, US | |
2136954 | 2136954 | 2022-12-01 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-02 04:21:07 | Dooly, Georgia, US | |
1965370 | 1965370 | 2022-11-30 | US | Georgia | Dooly | 13093 | 2723 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-12-01 04:21:03 | Dooly, Georgia, US | |
3027260 | 3027260 | 2022-11-17 | US | Illinois | Brown | 17009 | 2723 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-18 04:21:15 | Brown, Illinois, US | |
2488196 | 2488196 | 2022-11-16 | US | New Mexico | Colfax | 35007 | 2723 | 68 | 0 | 36.60569702 | -104.6472674 | 2022-11-17 04:21:11 | Colfax, New Mexico, US | |
295399 | 295399 | 2022-11-15 | US | Virginia | Northampton | 51131 | 2723 | 72 | 0 | 37.34062933 | -75.87751591 | 2022-11-16 04:21:09 | Northampton, Virginia, US | |
481930 | 481930 | 2022-11-08 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-09 04:21:22 | Jones, North Carolina, US | |
2441080 | 2441080 | 2022-11-07 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-08 04:21:21 | Jones, North Carolina, US | |
1052178 | 1052178 | 2022-11-06 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-07 04:21:26 | Jones, North Carolina, US | |
620202 | 620202 | 2022-11-05 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-06 04:21:24 | Jones, North Carolina, US | |
1024706 | 1024706 | 2022-11-04 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-05 04:21:52 | Jones, North Carolina, US | |
434883 | 434883 | 2022-11-03 | US | West Virginia | Webster | 54101 | 2723 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-11-04 04:22:11 | Webster, West Virginia, US | |
433697 | 433697 | 2022-11-03 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-04 04:22:11 | Jones, North Carolina, US | |
853125 | 853125 | 2022-11-02 | US | West Virginia | Webster | 54101 | 2723 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-11-03 04:22:05 | Webster, West Virginia, US | |
851939 | 851939 | 2022-11-02 | US | North Carolina | Jones | 37103 | 2723 | 47 | 0 | 35.02254606 | -77.35870791 | 2022-11-03 04:22:05 | Jones, North Carolina, US | |
3252294 | 3252294 | 2022-10-11 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-12 04:22:51 | Humboldt, Nevada, US | |
2969553 | 2969553 | 2022-10-10 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-11 04:23:05 | Humboldt, Nevada, US | |
3099589 | 3099589 | 2022-10-09 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-10 04:22:32 | Humboldt, Nevada, US | |
4004814 | 4004814 | 2022-10-08 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-09 04:21:16 | Humboldt, Nevada, US | |
398411 | 398411 | 2022-10-07 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-08 04:22:56 | Humboldt, Nevada, US | |
2531528 | 2531528 | 2022-10-06 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-07 04:23:08 | Humboldt, Nevada, US | |
1812922 | 1812922 | 2022-10-05 | US | Nevada | Humboldt | 32013 | 2723 | 66 | 0 | 41.40692186 | -118.1109427 | 2022-10-06 04:21:22 | Humboldt, Nevada, US | |
2686225 | 2686225 | 2022-10-03 | US | Arkansas | Scott | 5127 | 2723 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-10-04 04:22:55 | Scott, Arkansas, US | |
2772359 | 2772359 | 2022-09-26 | US | Virginia | Poquoson | 51735 | 2723 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-09-27 04:23:01 | Poquoson, Virginia, US | |
255226 | 255226 | 2022-09-08 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-09 04:21:11 | Howard, Missouri, US | |
3747024 | 3747024 | 2022-09-07 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-08 04:21:02 | Howard, Missouri, US | |
116664 | 116664 | 2022-09-06 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-07 04:20:59 | Howard, Missouri, US | |
2635636 | 2635636 | 2022-09-05 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-06 04:21:02 | Howard, Missouri, US | |
2989200 | 2989200 | 2022-09-04 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-05 04:21:01 | Howard, Missouri, US | |
2714885 | 2714885 | 2022-09-03 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-04 04:21:22 | Howard, Missouri, US | |
1395590 | 1395590 | 2022-09-02 | US | Missouri | Howard | 29089 | 2723 | 31 | 0 | 39.1435761 | -92.69756691 | 2022-09-03 04:21:04 | Howard, Missouri, US | |
3543300 | 3543300 | 2022-08-08 | China | Sichuan | 2723 | 3 | 0 | 30.6171 | 102.7103 | 2022-08-09 04:20:34 | Sichuan, China | |||
3872079 | 3872079 | 2022-07-31 | US | Arkansas | Pike | 5109 | 2723 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-08-01 04:21:03 | Pike, Arkansas, US | |
674833 | 674833 | 2022-07-30 | US | Arkansas | Pike | 5109 | 2723 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-31 04:21:02 | Pike, Arkansas, US | |
898562 | 898562 | 2022-07-24 | US | North Dakota | Mercer | 38057 | 2723 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-07-25 04:20:51 | Mercer, North Dakota, US | |
93556 | 93556 | 2022-07-23 | US | North Dakota | Mercer | 38057 | 2723 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-07-24 04:20:47 | Mercer, North Dakota, US | |
902578 | 902578 | 2022-07-22 | US | North Dakota | Mercer | 38057 | 2723 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-07-23 04:20:53 | Mercer, North Dakota, US | |
960235 | 960235 | 2022-07-19 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-20 04:20:59 | Rice, Kansas, US | |
3212139 | 3212139 | 2022-07-18 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-19 04:20:58 | Tunica, Mississippi, US | |
3211622 | 3211622 | 2022-07-18 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-19 04:20:58 | Rice, Kansas, US | |
3407314 | 3407314 | 2022-07-17 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-18 04:20:59 | Tunica, Mississippi, US | |
3406797 | 3406797 | 2022-07-17 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-18 04:20:59 | Rice, Kansas, US | |
2153514 | 2153514 | 2022-07-16 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-17 04:21:15 | Tunica, Mississippi, US | |
2152997 | 2152997 | 2022-07-16 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-17 04:21:15 | Rice, Kansas, US | |
2420747 | 2420747 | 2022-07-15 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-16 04:21:05 | Tunica, Mississippi, US | |
2420230 | 2420230 | 2022-07-15 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-16 04:21:05 | Rice, Kansas, US | |
3430822 | 3430822 | 2022-07-14 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-15 04:20:53 | Tunica, Mississippi, US | |
3430305 | 3430305 | 2022-07-14 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-15 04:20:53 | Rice, Kansas, US | |
3111342 | 3111342 | 2022-07-13 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-14 04:20:57 | Tunica, Mississippi, US | |
3110825 | 3110825 | 2022-07-13 | US | Kansas | Rice | 20159 | 2723 | 27 | 0 | 38.34616184 | -98.19992118 | 2022-07-14 04:20:57 | Rice, Kansas, US | |
633278 | 633278 | 2022-07-12 | US | Virginia | Lunenburg | 51111 | 2723 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-07-13 04:20:58 | Lunenburg, Virginia, US | |
631765 | 631765 | 2022-07-12 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-13 04:20:58 | Tunica, Mississippi, US | |
1213409 | 1213409 | 2022-07-11 | US | Mississippi | Tunica | 28143 | 2723 | 48 | 0 | 34.64967704 | -90.37481167 | 2022-07-12 04:20:51 | Tunica, Mississippi, US | |
1767731 | 1767731 | 2022-07-03 | US | Alabama | Lowndes | 1085 | 2723 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-07-04 04:20:54 | Lowndes, Alabama, US | |
3365717 | 3365717 | 2022-07-02 | US | Alabama | Lowndes | 1085 | 2723 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-07-03 04:20:59 | Lowndes, Alabama, US | |
594046 | 594046 | 2022-07-01 | US | Alabama | Lowndes | 1085 | 2723 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-07-02 04:21:16 | Lowndes, Alabama, US | |
3943398 | 3943398 | 2022-06-30 | US | Virginia | Floyd | 51063 | 2723 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-07-01 04:21:10 | Floyd, Virginia, US | |
2190570 | 2190570 | 2022-06-22 | US | Tennessee | Houston | 47083 | 2723 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-06-23 04:20:55 | Houston, Tennessee, US | |
2189778 | 2189778 | 2022-06-22 | US | New Hampshire | Unassigned | 90033 | 2723 | 6 | 0 | 44.69063265 | 0.0 | 2022-06-23 04:20:55 | Unassigned, New Hampshire, US | |
169001 | 169001 | 2022-06-21 | US | Tennessee | Houston | 47083 | 2723 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-06-22 04:20:54 | Houston, Tennessee, US | |
167046 | 167046 | 2022-06-21 | US | Illinois | Jasper | 17079 | 2723 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-06-22 04:20:54 | Jasper, Illinois, US | |
947810 | 947810 | 2022-06-14 | US | Idaho | Valley | 16085 | 2723 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-15 04:20:54 | Valley, Idaho, US | |
2980218 | 2980218 | 2022-06-13 | US | Idaho | Valley | 16085 | 2723 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-14 04:20:52 | Valley, Idaho, US | |
2084916 | 2084916 | 2022-05-15 | US | Idaho | Teton | 16081 | 2723 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-05-16 04:20:47 | Teton, Idaho, US | |
3355626 | 3355626 | 2022-05-14 | US | Idaho | Teton | 16081 | 2723 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-05-15 04:20:53 | Teton, Idaho, US | |
659271 | 659271 | 2022-05-13 | US | Idaho | Teton | 16081 | 2723 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-05-14 04:20:48 | Teton, Idaho, US | |
2333216 | 2333216 | 2022-05-08 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-09 04:20:54 | Noxubee, Mississippi, US | |
362178 | 362178 | 2022-05-07 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-08 04:20:49 | Noxubee, Mississippi, US | |
1399529 | 1399529 | 2022-05-06 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-07 04:21:09 | Noxubee, Mississippi, US | |
2599884 | 2599884 | 2022-05-05 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-06 04:21:00 | Noxubee, Mississippi, US | |
3267333 | 3267333 | 2022-05-04 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-05 04:20:55 | Noxubee, Mississippi, US | |
1573972 | 1573972 | 2022-05-03 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-04 04:20:59 | Noxubee, Mississippi, US | |
465232 | 465232 | 2022-05-02 | US | Mississippi | Noxubee | 28103 | 2723 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-05-03 04:21:00 | Noxubee, Mississippi, US | |
2030501 | 2030501 | 2022-04-24 | US | Minnesota | Koochiching | 27071 | 2723 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-04-25 04:20:56 | Koochiching, Minnesota, US | |
748076 | 748076 | 2022-04-23 | US | Minnesota | Koochiching | 27071 | 2723 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-04-24 04:20:56 | Koochiching, Minnesota, US | |
3438561 | 3438561 | 2022-04-22 | US | Minnesota | Koochiching | 27071 | 2723 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-04-23 04:20:50 | Koochiching, Minnesota, US | |
3731029 | 3731029 | 2022-04-03 | US | Georgia | Early | 13099 | 2723 | 61 | 0 | 31.32155345 | -84.90255207 | 2022-04-04 04:20:51 | Early, Georgia, US | |
500464 | 500464 | 2022-04-02 | US | Georgia | Early | 13099 | 2723 | 61 | 0 | 31.32155345 | -84.90255207 | 2022-04-03 04:20:48 | Early, Georgia, US | |
499484 | 499484 | 2022-04-02 | China | Zhejiang | 2723 | 1 | 0 | 29.1832 | 120.0934 | 2022-04-03 04:20:48 | Zhejiang, China | |||
3351449 | 3351449 | 2022-04-01 | US | Georgia | Early | 13099 | 2723 | 61 | 0 | 31.32155345 | -84.90255207 | 2022-04-02 04:20:47 | Early, Georgia, US | |
158808 | 158808 | 2022-03-29 | US | Georgia | Early | 13099 | 2723 | 60 | 0 | 31.32155345 | -84.90255207 | 2022-03-30 04:20:45 | Early, Georgia, US | |
1437379 | 1437379 | 2022-03-28 | US | Georgia | Early | 13099 | 2723 | 60 | 0 | 31.32155345 | -84.90255207 | 2022-03-29 04:20:46 | Early, Georgia, US | |
2142097 | 2142097 | 2022-03-09 | US | Missouri | Lewis | 29111 | 2723 | 34 | 0 | 40.09673161 | -91.72070156 | 2022-03-10 04:20:48 | Lewis, Missouri, US | |
3674212 | 3674212 | 2022-02-15 | US | Oklahoma | Haskell | 40061 | 2723 | 35 | 0 | 35.22257600000001 | -95.11513306 | 2022-02-16 04:21:10 | Haskell, Oklahoma, US | |
2644313 | 2644313 | 2022-02-14 | US | Oklahoma | Haskell | 40061 | 2723 | 35 | 0 | 35.22257600000001 | -95.11513306 | 2022-02-15 04:21:09 | Haskell, Oklahoma, US | |
188630 | 188630 | 2022-02-13 | US | Oklahoma | Haskell | 40061 | 2723 | 35 | 0 | 35.22257600000001 | -95.11513306 | 2022-02-14 04:20:51 | Haskell, Oklahoma, US | |
318994 | 318994 | 2022-02-12 | US | Texas | Eastland | 48133 | 2723 | 100 | 0 | 32.32743996 | -98.83243566 | 2022-02-13 04:21:00 | Eastland, Texas, US | |
318476 | 318476 | 2022-02-12 | US | Oklahoma | Haskell | 40061 | 2723 | 35 | 0 | 35.22257600000001 | -95.11513306 | 2022-02-13 04:21:00 | Haskell, Oklahoma, 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]);