johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
272 rows where confirmed = 2781 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351718 | 351718 | 2022-12-14 | US | Virginia | Sussex | 51183 | 2781 | 45 | 0 | 36.92432914 | -77.25791182 | 2022-12-15 04:20:58 | Sussex, Virginia, US | |
3745629 | 3745629 | 2022-09-07 | US | Arkansas | Pike | 5109 | 2781 | 45 | 0 | 34.16250414 | -93.65789349 | 2022-09-08 04:21:02 | Pike, Arkansas, US | |
117484 | 117484 | 2022-09-06 | US | Puerto Rico | Ceiba | 72037 | 2781 | 0 | 0 | 18.251818 | -65.666416 | 2022-09-07 04:20:59 | Ceiba, Puerto Rico, US | |
2636456 | 2636456 | 2022-09-05 | US | Puerto Rico | Ceiba | 72037 | 2781 | 0 | 0 | 18.251818 | -65.666416 | 2022-09-06 04:21:02 | Ceiba, Puerto Rico, US | |
2990020 | 2990020 | 2022-09-04 | US | Puerto Rico | Ceiba | 72037 | 2781 | 0 | 0 | 18.251818 | -65.666416 | 2022-09-05 04:21:01 | Ceiba, Puerto Rico, US | |
3776321 | 3776321 | 2022-08-30 | US | North Dakota | Mercer | 38057 | 2781 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-08-31 04:20:57 | Mercer, North Dakota, US | |
2853377 | 2853377 | 2022-08-22 | US | Arkansas | Perry | 5105 | 2781 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-08-23 04:20:56 | Perry, Arkansas, US | |
3649019 | 3649019 | 2022-08-14 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-15 04:20:59 | Livingston, Kentucky, US | |
1970025 | 1970025 | 2022-08-13 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-14 04:20:55 | Livingston, Kentucky, US | |
2889834 | 2889834 | 2022-08-12 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-13 04:20:52 | Livingston, Kentucky, US | |
3909439 | 3909439 | 2022-08-11 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-12 04:20:54 | Livingston, Kentucky, US | |
1347756 | 1347756 | 2022-08-10 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-11 04:20:49 | Livingston, Kentucky, US | |
1087511 | 1087511 | 2022-08-09 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-10 04:20:57 | Livingston, Kentucky, US | |
3544926 | 3544926 | 2022-08-08 | US | Kentucky | Livingston | 21139 | 2781 | 62 | 0 | 37.21137452 | -88.34797529 | 2022-08-09 04:20:34 | Livingston, Kentucky, US | |
1100725 | 1100725 | 2022-08-03 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-04 04:20:58 | Washita, Oklahoma, US | |
1407650 | 1407650 | 2022-08-02 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-03 04:20:59 | Washita, Oklahoma, US | |
3619688 | 3619688 | 2022-08-01 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-02 04:20:53 | Washita, Oklahoma, US | |
3874168 | 3874168 | 2022-07-31 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-01 04:21:03 | Washita, Oklahoma, US | |
676922 | 676922 | 2022-07-30 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-07-31 04:21:02 | Washita, Oklahoma, US | |
1786121 | 1786121 | 2022-07-29 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-07-30 04:20:42 | Washita, Oklahoma, US | |
1068484 | 1068484 | 2022-07-28 | US | Oklahoma | Washita | 40149 | 2781 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-07-29 04:20:45 | Washita, Oklahoma, US | |
1490543 | 1490543 | 2022-07-26 | US | Tennessee | Houston | 47083 | 2781 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-07-27 04:21:04 | Houston, Tennessee, US | |
2596989 | 2596989 | 2022-07-25 | US | Tennessee | Houston | 47083 | 2781 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-07-26 04:20:58 | Houston, Tennessee, US | |
1608913 | 1608913 | 2022-07-20 | US | Colorado | Prowers | 8099 | 2781 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-07-21 04:21:10 | Prowers, Colorado, US | |
959546 | 959546 | 2022-07-19 | US | Colorado | Prowers | 8099 | 2781 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-07-20 04:20:59 | Prowers, Colorado, US | |
1214897 | 1214897 | 2022-07-11 | US | Virginia | Galax | 51640 | 2781 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-07-12 04:20:51 | Galax, Virginia, US | |
2742849 | 2742849 | 2022-07-07 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-08 04:20:56 | Noxubee, Mississippi, US | |
1201644 | 1201644 | 2022-07-06 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-07 04:20:55 | Noxubee, Mississippi, US | |
3968387 | 3968387 | 2022-07-05 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-06 04:20:58 | Noxubee, Mississippi, US | |
3079898 | 3079898 | 2022-07-04 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-05 04:20:45 | Noxubee, Mississippi, US | |
1769180 | 1769180 | 2022-07-03 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-04 04:20:54 | Noxubee, Mississippi, US | |
3367166 | 3367166 | 2022-07-02 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-03 04:20:59 | Noxubee, Mississippi, US | |
595495 | 595495 | 2022-07-01 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-02 04:21:16 | Noxubee, Mississippi, US | |
3941896 | 3941896 | 2022-06-30 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-07-01 04:21:10 | Noxubee, Mississippi, US | |
2491854 | 2491854 | 2022-06-29 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-06-30 04:21:01 | Noxubee, Mississippi, US | |
2241236 | 2241236 | 2022-06-28 | US | Mississippi | Noxubee | 28103 | 2781 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-06-29 04:20:59 | Noxubee, Mississippi, US | |
949812 | 949812 | 2022-06-14 | US | Tennessee | Lake | 47095 | 2781 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-06-15 04:20:54 | Lake, Tennessee, US | |
3579339 | 3579339 | 2022-06-02 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-06-03 04:20:58 | Lafayette, Florida, US | |
971632 | 971632 | 2022-06-01 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-06-02 05:20:39 | Lafayette, Florida, US | |
971391 | 971391 | 2022-06-01 | US | Arkansas | Chicot | 5017 | 2781 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-06-02 05:20:39 | Chicot, Arkansas, US | |
229939 | 229939 | 2022-05-31 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-06-01 04:20:55 | Lafayette, Florida, US | |
3186704 | 3186704 | 2022-05-30 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-31 04:20:51 | Lafayette, Florida, US | |
3198853 | 3198853 | 2022-05-29 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-30 04:20:50 | Lafayette, Florida, US | |
2725731 | 2725731 | 2022-05-28 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-29 04:20:53 | Lafayette, Florida, US | |
1314912 | 1314912 | 2022-05-27 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-28 04:21:07 | Lafayette, Florida, US | |
1850704 | 1850704 | 2022-05-26 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-27 04:20:56 | Lafayette, Florida, US | |
2048580 | 2048580 | 2022-05-25 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-26 04:20:50 | Lafayette, Florida, US | |
3000018 | 3000018 | 2022-05-24 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-25 04:20:56 | Lafayette, Florida, US | |
3593739 | 3593739 | 2022-05-23 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-24 04:20:57 | Lafayette, Florida, US | |
622591 | 622591 | 2022-05-22 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-26 04:20:50 | Lafayette, Florida, US | |
1110287 | 1110287 | 2022-05-21 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-22 04:20:52 | Lafayette, Florida, US | |
1169911 | 1169911 | 2022-05-20 | US | Florida | Lafayette | 12067 | 2781 | 61 | 0 | 29.98484137 | -83.18166636 | 2022-05-21 04:20:58 | Lafayette, Florida, US | |
3917055 | 3917055 | 2022-05-01 | US | Illinois | Marshall | 17123 | 2781 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-05-02 04:21:10 | Marshall, Illinois, US | |
2841859 | 2841859 | 2022-04-30 | US | Illinois | Marshall | 17123 | 2781 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-05-01 04:20:57 | Marshall, Illinois, US | |
1158172 | 1158172 | 2022-04-29 | US | Illinois | Marshall | 17123 | 2781 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-30 04:21:05 | Marshall, Illinois, US | |
1697354 | 1697354 | 2022-04-28 | US | Illinois | Marshall | 17123 | 2781 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-29 04:20:59 | Marshall, Illinois, US | |
2030971 | 2030971 | 2022-04-24 | US | New Mexico | Los Alamos | 35028 | 2781 | 16 | 0 | 35.86631386 | -106.31349850000001 | 2022-04-25 04:20:56 | Los Alamos, New Mexico, US | |
748546 | 748546 | 2022-04-23 | US | New Mexico | Los Alamos | 35028 | 2781 | 16 | 0 | 35.86631386 | -106.31349850000001 | 2022-04-24 04:20:56 | Los Alamos, New Mexico, US | |
3439031 | 3439031 | 2022-04-22 | US | New Mexico | Los Alamos | 35028 | 2781 | 16 | 0 | 35.86631386 | -106.31349850000001 | 2022-04-23 04:20:50 | Los Alamos, New Mexico, US | |
264610 | 264610 | 2022-03-15 | US | Texas | Eastland | 48133 | 2781 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-03-16 04:20:50 | Eastland, Texas, US | |
2266969 | 2266969 | 2022-03-14 | US | Texas | Eastland | 48133 | 2781 | 112 | 0 | 32.32743996 | -98.83243566 | 2022-03-15 04:20:47 | Eastland, Texas, US | |
3631035 | 3631035 | 2022-03-13 | US | Texas | Eastland | 48133 | 2781 | 112 | 0 | 32.32743996 | -98.83243566 | 2022-03-14 04:20:46 | Eastland, Texas, US | |
2528408 | 2528408 | 2022-03-02 | US | Texas | Camp | 48063 | 2781 | 72 | 0 | 32.97195142 | -94.97790104 | 2022-03-03 04:21:01 | Camp, Texas, US | |
1995702 | 1995702 | 2022-03-01 | US | Texas | Camp | 48063 | 2781 | 72 | 0 | 32.97195142 | -94.97790104 | 2022-03-02 04:21:07 | Camp, Texas, US | |
2448336 | 2448336 | 2022-02-22 | US | Maine | Piscataquis | 23021 | 2781 | 27 | 0 | 45.83839062 | -69.2860223 | 2022-02-23 04:21:09 | Piscataquis, Maine, US | |
1300843 | 1300843 | 2022-02-17 | US | Puerto Rico | Villalba | 72149 | 2781 | 0 | 0 | 18.127951 | -66.473115 | 2022-02-18 04:21:04 | Villalba, Puerto Rico, US | |
3675098 | 3675098 | 2022-02-15 | US | Washington | Jefferson | 53031 | 2781 | 24 | 0 | 47.75003077 | -123.56097040000002 | 2022-02-16 04:21:10 | Jefferson, Washington, US | |
2645199 | 2645199 | 2022-02-14 | US | Washington | Jefferson | 53031 | 2781 | 24 | 0 | 47.75003077 | -123.56097040000002 | 2022-02-15 04:21:09 | Jefferson, Washington, US | |
2644544 | 2644544 | 2022-02-14 | US | Puerto Rico | Villalba | 72149 | 2781 | 0 | 0 | 18.127951 | -66.473115 | 2022-02-15 04:21:09 | Villalba, Puerto Rico, US | |
188861 | 188861 | 2022-02-13 | US | Puerto Rico | Villalba | 72149 | 2781 | 0 | 0 | 18.127951 | -66.473115 | 2022-02-14 04:20:51 | Villalba, Puerto Rico, US | |
1465559 | 1465559 | 2022-02-10 | US | Kentucky | Todd | 21219 | 2781 | 40 | 0 | 36.8381152 | -87.17878374 | 2022-02-11 04:21:09 | Todd, Kentucky, US | |
1782019 | 1782019 | 2022-01-27 | US | Oregon | Morrow | 41049 | 2781 | 26 | 0 | 45.41846568 | -119.584546 | 2022-01-28 04:21:09 | Morrow, Oregon, US | |
3466674 | 3466674 | 2022-01-18 | US | Ohio | Morgan | 39115 | 2781 | 48 | 0 | 39.62081738 | -81.85308173 | 2022-01-19 04:21:23 | Morgan, Ohio, US | |
1474870 | 1474870 | 2022-01-17 | US | Puerto Rico | Lares | 72081 | 2781 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-01-18 04:21:04 | Lares, Puerto Rico, US | |
1472941 | 1472941 | 2022-01-17 | US | Georgia | Jasper | 13159 | 2781 | 62 | 0 | 33.31535543 | -83.68844964 | 2022-01-18 04:21:04 | Jasper, Georgia, US | |
557263 | 557263 | 2022-01-16 | US | Ohio | Harrison | 39067 | 2781 | 66 | 0 | 40.29380509 | -81.09068544 | 2022-01-17 04:21:08 | Harrison, Ohio, US | |
126441 | 126441 | 2022-01-09 | Bhutan | 2781 | 3 | 0 | 27.5142 | 90.4336 | 2022-01-10 04:22:07 | Bhutan | ||||
2613328 | 2613328 | 2022-01-06 | US | Vermont | Addison | 50001 | 2781 | 10 | 0 | 44.03217337 | -73.14130877 | 2022-01-07 04:22:09 | Addison, Vermont, US | |
2612182 | 2612182 | 2022-01-06 | US | Nebraska | York | 31185 | 2781 | 11 | 0 | 40.87272618 | -97.59710186 | 2022-01-07 04:22:09 | York, Nebraska, US | |
1670026 | 1670026 | 2021-12-29 | US | Maine | Washington | 23029 | 2781 | 39 | 0 | 45.01607142 | -67.62813524 | 2021-12-30 04:21:25 | Washington, Maine, US | |
2113626 | 2113626 | 2021-12-26 | US | Missouri | Livingston | 29117 | 2781 | 80 | 0 | 39.78110272 | -93.54645978 | 2021-12-27 04:21:58 | Livingston, Missouri, US | |
3606998 | 3606998 | 2021-12-25 | US | Missouri | Livingston | 29117 | 2781 | 80 | 0 | 39.78110272 | -93.54645978 | 2021-12-26 04:21:50 | Livingston, Missouri, US | |
2965316 | 2965316 | 2021-12-24 | US | Missouri | Livingston | 29117 | 2781 | 80 | 0 | 39.78110272 | -93.54645978 | 2021-12-25 04:21:37 | Livingston, Missouri, US | |
3818348 | 3818348 | 2021-12-23 | US | Missouri | Livingston | 29117 | 2781 | 80 | 0 | 39.78110272 | -93.54645978 | 2021-12-24 04:21:34 | Livingston, Missouri, US | |
2904719 | 2904719 | 2021-12-19 | US | Illinois | Jo Daviess | 17085 | 2781 | 31 | 0 | 42.36542373 | -90.21094405 | 2021-12-20 04:21:43 | Jo Daviess, Illinois, US | |
1259792 | 1259792 | 2021-12-18 | US | Illinois | Jo Daviess | 17085 | 2781 | 31 | 0 | 42.36542373 | -90.21094405 | 2021-12-19 04:21:11 | Jo Daviess, Illinois, US | |
2399820 | 2399820 | 2021-12-17 | US | Illinois | Jo Daviess | 17085 | 2781 | 31 | 0 | 42.36542373 | -90.21094405 | 2021-12-18 02:22:20 | Jo Daviess, Illinois, US | |
1718429 | 1718429 | 2021-12-16 | US | Nebraska | Gage | 31067 | 2781 | 19 | 0 | 40.26186809 | -96.68946704 | 2021-12-17 04:22:14 | Gage, Nebraska, US | |
1663696 | 1663696 | 2021-12-12 | US | Utah | San Juan | 49037 | 2781 | 43 | 0 | 37.62762978 | -109.80337140000002 | 2021-12-13 04:22:02 | San Juan, Utah, US | |
1661394 | 1661394 | 2021-12-12 | US | Illinois | Carroll | 17015 | 2781 | 41 | 0 | 42.06823429 | -89.93395545 | 2021-12-13 04:22:02 | Carroll, Illinois, US | |
1667712 | 1667712 | 2021-12-11 | US | Utah | San Juan | 49037 | 2781 | 43 | 0 | 37.62762978 | -109.80337140000002 | 2021-12-12 04:22:12 | San Juan, Utah, US | |
1665410 | 1665410 | 2021-12-11 | US | Illinois | Carroll | 17015 | 2781 | 41 | 0 | 42.06823429 | -89.93395545 | 2021-12-12 04:22:12 | Carroll, Illinois, US | |
3658864 | 3658864 | 2021-12-10 | US | Utah | San Juan | 49037 | 2781 | 43 | 0 | 37.62762978 | -109.80337140000002 | 2021-12-11 04:22:45 | San Juan, Utah, US | |
3656562 | 3656562 | 2021-12-10 | US | Illinois | Carroll | 17015 | 2781 | 41 | 0 | 42.06823429 | -89.93395545 | 2021-12-11 04:22:45 | Carroll, Illinois, US | |
1078626 | 1078626 | 2021-12-09 | US | Florida | Hamilton | 12047 | 2781 | 25 | 0 | 30.49673973 | -82.94998918 | 2021-12-10 04:22:28 | Hamilton, Florida, US | |
551475 | 551475 | 2021-12-08 | US | Florida | Hamilton | 12047 | 2781 | 25 | 0 | 30.49673973 | -82.94998918 | 2021-12-09 04:22:49 | Hamilton, Florida, US | |
404995 | 404995 | 2021-12-07 | US | Florida | Hamilton | 12047 | 2781 | 25 | 0 | 30.49673973 | -82.94998918 | 2021-12-08 04:22:46 | Hamilton, Florida, US | |
1031077 | 1031077 | 2021-12-06 | US | Florida | Hamilton | 12047 | 2781 | 25 | 0 | 30.49673973 | -82.94998918 | 2021-12-07 04:22:34 | Hamilton, Florida, US | |
1741240 | 1741240 | 2021-12-05 | US | Florida | Hamilton | 12047 | 2781 | 25 | 0 | 30.49673973 | -82.94998918 | 2021-12-06 04:22:34 | Hamilton, Florida, US | |
138672 | 138672 | 2021-12-04 | US | Florida | Hamilton | 12047 | 2781 | 25 | 0 | 30.49673973 | -82.94998918 | 2021-12-05 04:22:25 | Hamilton, Florida, 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]);