johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where confirmed = 5139 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150563 | 1150563 | 2022-12-12 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-13 04:21:01 | Antrim, Michigan, US | |
870417 | 870417 | 2022-12-11 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-12 04:21:01 | Antrim, Michigan, US | |
258947 | 258947 | 2022-12-10 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-11 04:20:50 | Antrim, Michigan, US | |
3937661 | 3937661 | 2022-12-09 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-10 04:21:02 | Antrim, Michigan, US | |
3378993 | 3378993 | 2022-12-08 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-09 04:21:05 | Antrim, Michigan, US | |
1986264 | 1986264 | 2022-12-07 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-08 04:21:07 | Antrim, Michigan, US | |
3715787 | 3715787 | 2022-12-06 | US | Michigan | Antrim | 26009 | 5139 | 76 | 0 | 44.99690221 | -85.15503082 | 2022-12-07 04:20:58 | Antrim, Michigan, US | |
719481 | 719481 | 2022-12-04 | US | Illinois | Hancock | 17067 | 5139 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-05 04:20:58 | Hancock, Illinois, US | |
2817770 | 2817770 | 2022-12-03 | US | Illinois | Hancock | 17067 | 5139 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-04 04:20:56 | Hancock, Illinois, US | |
834626 | 834626 | 2022-12-02 | US | Illinois | Hancock | 17067 | 5139 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-03 04:21:02 | Hancock, Illinois, US | |
2138912 | 2138912 | 2022-12-01 | US | Puerto Rico | Jayuya | 72073 | 5139 | 0 | 0 | 18.211446 | -66.58878 | 2022-12-02 04:21:07 | Jayuya, Puerto Rico, US | |
1967328 | 1967328 | 2022-11-30 | US | Puerto Rico | Jayuya | 72073 | 5139 | 0 | 0 | 18.211446 | -66.58878 | 2022-12-01 04:21:03 | Jayuya, Puerto Rico, US | |
3573518 | 3573518 | 2022-09-19 | US | Tennessee | Bledsoe | 47007 | 5139 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-09-20 04:22:48 | Bledsoe, Tennessee, US | |
3953172 | 3953172 | 2022-08-17 | US | Pennsylvania | Juniata | 42067 | 5139 | 183 | 0 | 40.53358749 | -77.3997513 | 2022-08-18 04:21:11 | Juniata, Pennsylvania, US | |
2888901 | 2888901 | 2022-08-12 | US | Arkansas | Lincoln | 5079 | 5139 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-08-13 04:20:52 | Lincoln, Arkansas, US | |
900716 | 900716 | 2022-07-22 | US | California | Inyo | 6027 | 5139 | 57 | 0 | 36.51112084 | -117.4111978 | 2022-07-23 04:20:53 | Inyo, California, US | |
960116 | 960116 | 2022-07-19 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-20 04:20:59 | Mahaska, Iowa, US | |
3211503 | 3211503 | 2022-07-18 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-19 04:20:58 | Mahaska, Iowa, US | |
3210883 | 3210883 | 2022-07-18 | US | Colorado | Alamosa | 8003 | 5139 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-07-19 04:20:58 | Alamosa, Colorado, US | |
3406678 | 3406678 | 2022-07-17 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-18 04:20:59 | Mahaska, Iowa, US | |
2152878 | 2152878 | 2022-07-16 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-17 04:21:15 | Mahaska, Iowa, US | |
2420111 | 2420111 | 2022-07-15 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-16 04:21:05 | Mahaska, Iowa, US | |
3430186 | 3430186 | 2022-07-14 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-15 04:20:53 | Mahaska, Iowa, US | |
3110706 | 3110706 | 2022-07-13 | US | Iowa | Mahaska | 19123 | 5139 | 90 | 0 | 41.33521503 | -92.64083907 | 2022-07-14 04:20:57 | Mahaska, Iowa, US | |
1420265 | 1420265 | 2022-07-08 | US | Texas | Milam | 48331 | 5139 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-07-09 04:20:59 | Milam, Texas, US | |
560754 | 560754 | 2022-06-16 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-17 04:20:56 | Perry, Missouri, US | |
3984556 | 3984556 | 2022-06-15 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-16 04:20:55 | Perry, Missouri, US | |
948797 | 948797 | 2022-06-14 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-15 04:20:54 | Perry, Missouri, US | |
2981205 | 2981205 | 2022-06-13 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-14 04:20:52 | Perry, Missouri, US | |
2237331 | 2237331 | 2022-06-12 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-13 04:21:14 | Perry, Missouri, US | |
2235735 | 2235735 | 2022-06-12 | US | Alabama | Butler | 1013 | 5139 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-13 04:21:14 | Butler, Alabama, US | |
3143529 | 3143529 | 2022-06-11 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-12 04:20:53 | Perry, Missouri, US | |
3141933 | 3141933 | 2022-06-11 | US | Alabama | Butler | 1013 | 5139 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-12 04:20:53 | Butler, Alabama, US | |
1946445 | 1946445 | 2022-06-10 | US | Missouri | Perry | 29157 | 5139 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-11 04:21:01 | Perry, Missouri, US | |
1944849 | 1944849 | 2022-06-10 | US | Alabama | Butler | 1013 | 5139 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-11 04:21:01 | Butler, Alabama, US | |
1421724 | 1421724 | 2022-06-08 | US | Colorado | Elbert | 8039 | 5139 | 41 | 0 | 39.28656773 | -104.1358721 | 2022-06-09 04:20:54 | Elbert, Colorado, US | |
3728937 | 3728937 | 2022-06-07 | US | Puerto Rico | Anasco | 72011 | 5139 | 0 | 0 | 18.287985 | -67.120611 | 2022-06-08 04:20:55 | Anasco, Puerto Rico, US | |
3510029 | 3510029 | 2022-06-05 | US | Oregon | Union | 41061 | 5139 | 82 | 0 | 45.30915495 | -118.0068979 | 2022-06-06 04:20:57 | Union, Oregon, US | |
3530106 | 3530106 | 2022-06-04 | US | Oregon | Union | 41061 | 5139 | 82 | 0 | 45.30915495 | -118.0068979 | 2022-06-05 04:20:55 | Union, Oregon, US | |
3136192 | 3136192 | 2022-06-03 | US | Oregon | Union | 41061 | 5139 | 82 | 0 | 45.30915495 | -118.0068979 | 2022-06-04 04:20:58 | Union, Oregon, US | |
3581267 | 3581267 | 2022-06-02 | US | Oregon | Union | 41061 | 5139 | 82 | 0 | 45.30915495 | -118.0068979 | 2022-06-03 04:20:58 | Union, Oregon, US | |
974078 | 974078 | 2022-06-01 | US | Texas | Limestone | 48293 | 5139 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-06-02 05:20:39 | Limestone, Texas, US | |
1314704 | 1314704 | 2022-05-27 | US | Arkansas | Logan | 5083 | 5139 | 78 | 0 | 35.21413234 | -93.71951016 | 2022-05-28 04:21:07 | Logan, Arkansas, US | |
2999810 | 2999810 | 2022-05-24 | US | Arkansas | Logan | 5083 | 5139 | 79 | 0 | 35.21413234 | -93.71951016 | 2022-05-25 04:20:56 | Logan, Arkansas, US | |
3596422 | 3596422 | 2022-05-23 | US | Virginia | Prince Edward | 51147 | 5139 | 71 | 0 | 37.22554789 | -78.43597949 | 2022-05-24 04:20:57 | Prince Edward, Virginia, US | |
3593381 | 3593381 | 2022-05-23 | US | Alabama | Cherokee | 1019 | 5139 | 86 | 0 | 34.17805983 | -85.60638968 | 2022-05-24 04:20:57 | Cherokee, Alabama, US | |
1574477 | 1574477 | 2022-05-03 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-05-04 04:20:59 | Madison, North Carolina, US | |
465737 | 465737 | 2022-05-02 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-05-03 04:21:00 | Madison, North Carolina, US | |
3918376 | 3918376 | 2022-05-01 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-05-02 04:21:10 | Madison, North Carolina, US | |
2843180 | 2843180 | 2022-04-30 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-05-01 04:20:57 | Madison, North Carolina, US | |
1159493 | 1159493 | 2022-04-29 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-04-30 04:21:05 | Madison, North Carolina, US | |
1698675 | 1698675 | 2022-04-28 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-04-29 04:20:59 | Madison, North Carolina, US | |
3854158 | 3854158 | 2022-04-27 | US | North Carolina | Madison | 37115 | 5139 | 80 | 0 | 35.85402722 | -82.71346418 | 2022-04-28 04:20:47 | Madison, North Carolina, US | |
1226937 | 1226937 | 2022-04-14 | US | Virginia | Fluvanna | 51065 | 5139 | 43 | 0 | 37.84157909 | -78.27715475 | 2022-04-15 04:20:57 | Fluvanna, Virginia, US | |
2444321 | 2444321 | 2022-04-13 | US | Maine | Sagadahoc | 23023 | 5139 | 32 | 0 | 43.95415864 | -69.85074999 | 2022-04-13 23:21:06 | Sagadahoc, Maine, US | |
3024231 | 3024231 | 2022-03-23 | US | Missouri | Ray | 29177 | 5139 | 93 | 0 | 39.353746799999996 | -93.98905745 | 2022-03-24 04:20:43 | Ray, Missouri, US | |
1659370 | 1659370 | 2022-03-19 | US | Tennessee | Johnson | 47091 | 5139 | 88 | 0 | 36.45523950000001 | -81.84886538 | 2022-03-20 04:20:45 | Johnson, Tennessee, US | |
338896 | 338896 | 2022-03-18 | US | Tennessee | Johnson | 47091 | 5139 | 88 | 0 | 36.45523950000001 | -81.84886538 | 2022-03-19 04:20:47 | Johnson, Tennessee, US | |
1994860 | 1994860 | 2022-03-01 | US | New Mexico | Lincoln | 35027 | 5139 | 64 | 0 | 33.74526079 | -105.4586166 | 2022-03-02 04:21:07 | Lincoln, New Mexico, US | |
1060150 | 1060150 | 2022-02-23 | US | North Carolina | Caswell | 37033 | 5139 | 43 | 0 | 36.39312665 | -79.33353281 | 2022-02-24 04:21:14 | Caswell, North Carolina, US | |
2447162 | 2447162 | 2022-02-22 | US | Alabama | Marengo | 1091 | 5139 | 103 | 0 | 32.24767634 | -87.78796182 | 2022-02-23 04:21:09 | Marengo, Alabama, US | |
3876049 | 3876049 | 2022-02-19 | US | Arkansas | Clark | 5019 | 5139 | 74 | 0 | 34.04613432 | -93.17484713 | 2022-02-20 04:21:00 | Clark, Arkansas, US | |
2015921 | 2015921 | 2022-02-06 | US | Texas | San Jacinto | 48407 | 5139 | 92 | 0 | 30.57933681 | -95.16260304 | 2022-02-07 04:21:05 | San Jacinto, Texas, US | |
461615 | 461615 | 2022-02-02 | US | New York | Essex | 36031 | 5139 | 52 | 0 | 44.11630765 | -73.77297842 | 2022-02-03 04:21:21 | Essex, New York, US | |
3063866 | 3063866 | 2022-01-29 | US | Missouri | Adair | 29001 | 5139 | 56 | 0 | 40.19058551 | -92.60078167 | 2022-01-30 04:21:26 | Adair, Missouri, US | |
1229027 | 1229027 | 2022-01-24 | US | Kentucky | Harrison | 21097 | 5139 | 57 | 0 | 38.44188174 | -84.32869741 | 2022-01-25 04:21:05 | Harrison, Kentucky, US | |
1963383 | 1963383 | 2022-01-20 | US | South Carolina | Jasper | 45053 | 5139 | 82 | 0 | 32.43171982 | -81.02487495 | 2022-01-21 04:21:09 | Jasper, South Carolina, US | |
128436 | 128436 | 2022-01-09 | US | Minnesota | Brown | 27015 | 5139 | 69 | 0 | 44.24205652 | -94.72562874 | 2022-01-10 04:22:07 | Brown, Minnesota, US | |
1217271 | 1217271 | 2022-01-08 | US | Minnesota | Brown | 27015 | 5139 | 69 | 0 | 44.24205652 | -94.72562874 | 2022-01-09 04:21:46 | Brown, Minnesota, US | |
1391364 | 1391364 | 2022-01-07 | US | Minnesota | Brown | 27015 | 5139 | 69 | 0 | 44.24205652 | -94.72562874 | 2022-01-08 04:21:53 | Brown, Minnesota, US | |
2610404 | 2610404 | 2022-01-06 | US | Alabama | Clarke | 1025 | 5139 | 89 | 0 | 31.68099859 | -87.83548597 | 2022-01-07 04:22:09 | Clarke, Alabama, US | |
1742878 | 1742878 | 2021-12-05 | US | North Carolina | Macon | 37113 | 5139 | 80 | 0 | 35.14867843 | -83.41696617 | 2021-12-06 04:22:34 | Macon, North Carolina, US | |
140310 | 140310 | 2021-12-04 | US | North Carolina | Macon | 37113 | 5139 | 80 | 0 | 35.14867843 | -83.41696617 | 2021-12-05 04:22:25 | Macon, North Carolina, US | |
2197963 | 2197963 | 2021-12-03 | US | North Carolina | Macon | 37113 | 5139 | 80 | 0 | 35.14867843 | -83.41696617 | 2021-12-04 04:22:18 | Macon, North Carolina, US | |
847 | 847 | 2021-12-02 | US | Arkansas | Poinsett | 5111 | 5139 | 102 | 0 | 35.57433534 | -90.66268713 | 2021-12-03 04:23:05 | Poinsett, Arkansas, US | |
1015348 | 1015348 | 2021-11-21 | US | Illinois | Logan | 17107 | 5139 | 76 | 0 | 40.12581572 | -89.36638784 | 2021-11-22 04:22:20 | Logan, Illinois, US | |
723512 | 723512 | 2021-11-20 | US | Illinois | Logan | 17107 | 5139 | 76 | 0 | 40.12581572 | -89.36638784 | 2021-11-21 04:22:13 | Logan, Illinois, US | |
163042 | 163042 | 2021-11-19 | US | Illinois | Logan | 17107 | 5139 | 76 | 0 | 40.12581572 | -89.36638784 | 2021-11-20 04:22:17 | Logan, Illinois, US | |
2847310 | 2847310 | 2021-11-10 | US | Ohio | Coshocton | 39031 | 5139 | 107 | 0 | 40.30096166 | -81.91729018 | 2021-11-11 04:21:45 | Coshocton, Ohio, US | |
3643140 | 3643140 | 2021-11-08 | US | Wisconsin | Trempealeau | 55121 | 5139 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-11-09 04:21:36 | Trempealeau, Wisconsin, US | |
2003609 | 2003609 | 2021-11-07 | US | Tennessee | Hardeman | 47069 | 5139 | 82 | 0 | 35.20772017 | -88.99161161 | 2021-11-08 04:21:43 | Hardeman, Tennessee, US | |
3122897 | 3122897 | 2021-11-05 | US | Kentucky | Clay | 21051 | 5139 | 59 | 0 | 37.16451126 | -83.712575 | 2021-11-06 04:21:51 | Clay, Kentucky, US | |
45005 | 45005 | 2021-11-02 | US | Kansas | Harvey | 20079 | 5139 | 84 | 0 | 38.04293782 | -97.42747573 | 2021-11-03 06:22:09 | Harvey, Kansas, US | |
3512701 | 3512701 | 2021-11-01 | US | Kansas | Harvey | 20079 | 5139 | 84 | 0 | 38.04293782 | -97.42747573 | 2021-11-02 04:22:03 | Harvey, Kansas, US | |
5374 | 5374 | 2021-10-28 | US | Illinois | Morgan | 17137 | 5139 | 100 | 0 | 39.71654544 | -90.20255104 | 2021-10-29 04:22:03 | Morgan, Illinois, US | |
685123 | 685123 | 2021-10-24 | US | Puerto Rico | Toa Baja | 72137 | 5139 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-10-25 04:22:31 | Toa Baja, Puerto Rico, US | |
683443 | 683443 | 2021-10-24 | US | Indiana | Jefferson | 18077 | 5139 | 97 | 0 | 38.78576239 | -85.43633383 | 2021-10-25 04:22:31 | Jefferson, Indiana, US | |
655377 | 655377 | 2021-10-22 | US | Kentucky | Calloway | 21035 | 5139 | 60 | 0 | 36.62093411 | -88.2731593 | 2021-10-23 04:21:32 | Calloway, Kentucky, US | |
2125672 | 2125672 | 2021-10-21 | US | Missouri | Marion | 29127 | 5139 | 63 | 0 | 39.80601912 | -91.62203062 | 2021-10-22 04:21:14 | Marion, Missouri, US | |
2124273 | 2124273 | 2021-10-21 | US | Arkansas | Unassigned | 90005 | 5139 | 0 | 0 | 36.38177105 | 0.0 | 2021-10-22 04:21:14 | Unassigned, Arkansas, US | |
2123575 | 2123575 | 2021-10-21 | Colombia | Guaviare | 5139 | 97 | 0 | 1.0654 | -73.2603 | 2021-10-22 04:21:14 | Guaviare, Colombia | |||
443187 | 443187 | 2021-10-20 | Colombia | Guaviare | 5139 | 97 | 0 | 1.0654 | -73.2603 | 2021-10-21 04:21:18 | Guaviare, Colombia | |||
597506 | 597506 | 2021-10-19 | Colombia | Guaviare | 5139 | 97 | 0 | 1.0654 | -73.2603 | 2021-10-20 04:21:00 | Guaviare, Colombia | |||
493557 | 493557 | 2021-10-14 | US | Missouri | Lawrence | 29109 | 5139 | 104 | 0 | 37.10626634 | -93.83293097 | 2021-10-15 04:21:26 | Lawrence, Missouri, US | |
2960846 | 2960846 | 2021-10-08 | US | Kentucky | Taylor | 21217 | 5139 | 72 | 0 | 37.3677562 | -85.3329931 | 2021-10-09 04:21:34 | Taylor, Kentucky, US | |
468382 | 468382 | 2021-10-07 | US | Illinois | Christian | 17021 | 5139 | 82 | 0 | 39.54581621 | -89.27780482 | 2021-10-08 04:21:25 | Christian, Illinois, US | |
1276756 | 1276756 | 2021-10-03 | US | Ohio | Guernsey | 39059 | 5139 | 69 | 0 | 40.05026529 | -81.49248905 | 2021-10-04 04:21:31 | Guernsey, Ohio, US | |
1887810 | 1887810 | 2021-09-12 | US | South Carolina | Colleton | 45029 | 5139 | 156 | 0 | 32.87582989 | -80.67641292 | 2021-09-13 04:21:15 | Colleton, South Carolina, US | |
1886822 | 1886822 | 2021-09-12 | US | Mississippi | Lincoln | 28085 | 5139 | 127 | 0 | 31.53288662 | -90.45391915 | 2021-09-13 04:21:15 | Lincoln, Mississippi, US | |
3808713 | 3808713 | 2021-09-11 | US | South Carolina | Colleton | 45029 | 5139 | 156 | 0 | 32.87582989 | -80.67641292 | 2021-09-12 04:21:13 | Colleton, South Carolina, 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]);