johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
180 rows where confirmed = 4830 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1967982 | 1967982 | 2022-11-30 | US | Virginia | Rockbridge | 51163 | 4830 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-12-01 04:21:03 | Rockbridge, Virginia, US | |
2559752 | 2559752 | 2022-11-29 | US | Texas | Llano | 48299 | 4830 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-11-30 04:21:07 | Llano, Texas, US | |
1242826 | 1242826 | 2022-11-28 | US | Texas | Llano | 48299 | 4830 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-11-29 04:21:05 | Llano, Texas, US | |
1620635 | 1620635 | 2022-11-22 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-23 04:21:06 | Clay, Alabama, US | |
3460523 | 3460523 | 2022-11-21 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-22 04:20:47 | Clay, Alabama, US | |
1640708 | 1640708 | 2022-11-20 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-21 04:21:05 | Clay, Alabama, US | |
2064265 | 2064265 | 2022-11-19 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-20 04:21:08 | Clay, Alabama, US | |
1755659 | 1755659 | 2022-11-18 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-19 04:21:14 | Clay, Alabama, US | |
3026652 | 3026652 | 2022-11-17 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-18 04:21:15 | Clay, Alabama, US | |
2486363 | 2486363 | 2022-11-16 | US | Alabama | Clay | 1027 | 4830 | 90 | 0 | 33.26984193 | -85.85836077 | 2022-11-17 04:21:11 | Clay, Alabama, US | |
1366263 | 1366263 | 2022-10-28 | China | Fujian | 4830 | 1 | 0 | 26.0789 | 117.9874 | 2022-10-29 04:21:13 | Fujian, China | |||
3038118 | 3038118 | 2022-10-27 | China | Fujian | 4830 | 1 | 0 | 26.0789 | 117.9874 | 2022-10-28 04:22:31 | Fujian, China | |||
2160974 | 2160974 | 2022-10-16 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-17 04:20:31 | Magoffin, Kentucky, US | |
517171 | 517171 | 2022-10-15 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-16 04:22:39 | Magoffin, Kentucky, US | |
2034228 | 2034228 | 2022-10-14 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-15 04:22:00 | Magoffin, Kentucky, US | |
3755427 | 3755427 | 2022-10-13 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-14 04:22:28 | Pike, Missouri, US | |
3754916 | 3754916 | 2022-10-13 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-14 04:22:28 | Magoffin, Kentucky, US | |
3216252 | 3216252 | 2022-10-12 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-13 04:22:39 | Pike, Missouri, US | |
3215741 | 3215741 | 2022-10-12 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-13 04:22:39 | Magoffin, Kentucky, US | |
3252101 | 3252101 | 2022-10-11 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-12 04:22:51 | Pike, Missouri, US | |
3251590 | 3251590 | 2022-10-11 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-12 04:22:51 | Magoffin, Kentucky, US | |
2969360 | 2969360 | 2022-10-10 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-11 04:23:05 | Pike, Missouri, US | |
2968849 | 2968849 | 2022-10-10 | US | Kentucky | Magoffin | 21153 | 4830 | 57 | 0 | 37.70820545 | -83.0657714 | 2022-10-11 04:23:05 | Magoffin, Kentucky, US | |
3099396 | 3099396 | 2022-10-09 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-10 04:22:32 | Pike, Missouri, US | |
4004621 | 4004621 | 2022-10-08 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-09 04:21:16 | Pike, Missouri, US | |
398218 | 398218 | 2022-10-07 | US | Missouri | Pike | 29163 | 4830 | 65 | 0 | 39.34310674 | -91.16980779 | 2022-10-08 04:22:56 | Pike, Missouri, US | |
2532888 | 2532888 | 2022-10-06 | US | West Virginia | Morgan | 54065 | 4830 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-07 04:23:08 | Morgan, West Virginia, US | |
994481 | 994481 | 2022-08-16 | US | West Virginia | Hardy | 54031 | 4830 | 50 | 0 | 39.00683177 | -78.85855301 | 2022-08-17 04:20:59 | Hardy, West Virginia, US | |
2495648 | 2495648 | 2022-08-15 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-16 04:20:58 | Antrim, Michigan, US | |
2495094 | 2495094 | 2022-08-15 | US | Illinois | White | 17193 | 4830 | 51 | 0 | 38.08706198 | -88.17657461 | 2022-08-16 04:20:58 | White, Illinois, US | |
3649198 | 3649198 | 2022-08-14 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-15 04:20:59 | Antrim, Michigan, US | |
1970204 | 1970204 | 2022-08-13 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-14 04:20:55 | Antrim, Michigan, US | |
2890013 | 2890013 | 2022-08-12 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-13 04:20:52 | Antrim, Michigan, US | |
3909618 | 3909618 | 2022-08-11 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-12 04:20:54 | Antrim, Michigan, US | |
1347935 | 1347935 | 2022-08-10 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-11 04:20:49 | Antrim, Michigan, US | |
1087690 | 1087690 | 2022-08-09 | US | Michigan | Antrim | 26009 | 4830 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-08-10 04:20:57 | Antrim, Michigan, US | |
2338606 | 2338606 | 2022-07-27 | US | Texas | Robertson | 48395 | 4830 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-07-28 04:20:56 | Robertson, Texas, US | |
961745 | 961745 | 2022-07-19 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-20 04:20:59 | Beadle, South Dakota, US | |
3213132 | 3213132 | 2022-07-18 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-19 04:20:58 | Beadle, South Dakota, US | |
3408307 | 3408307 | 2022-07-17 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-18 04:20:59 | Beadle, South Dakota, US | |
2154507 | 2154507 | 2022-07-16 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-17 04:21:15 | Beadle, South Dakota, US | |
2421740 | 2421740 | 2022-07-15 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-16 04:21:05 | Beadle, South Dakota, US | |
3431815 | 3431815 | 2022-07-14 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-15 04:20:53 | Beadle, South Dakota, US | |
3112335 | 3112335 | 2022-07-13 | US | South Dakota | Beadle | 46005 | 4830 | 60 | 0 | 44.41464384 | -98.27858469 | 2022-07-14 04:20:57 | Beadle, South Dakota, US | |
3397978 | 3397978 | 2022-06-18 | US | California | Inyo | 6027 | 4830 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-06-19 04:20:51 | Inyo, California, US | |
3726966 | 3726966 | 2022-06-07 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-08 04:20:55 | Appling, Georgia, US | |
3888368 | 3888368 | 2022-06-06 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-07 04:21:08 | Appling, Georgia, US | |
3508137 | 3508137 | 2022-06-05 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-06 04:20:57 | Appling, Georgia, US | |
3528214 | 3528214 | 2022-06-04 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-05 04:20:55 | Appling, Georgia, US | |
3134300 | 3134300 | 2022-06-03 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-04 04:20:58 | Appling, Georgia, US | |
3579375 | 3579375 | 2022-06-02 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-03 04:20:58 | Appling, Georgia, US | |
971668 | 971668 | 2022-06-01 | US | Georgia | Appling | 13001 | 4830 | 128 | 0 | 31.74847232 | -82.28909114 | 2022-06-02 05:20:39 | Appling, Georgia, US | |
1853372 | 1853372 | 2022-05-26 | US | Virginia | New Kent | 51127 | 4830 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-05-27 04:20:56 | New Kent, Virginia, US | |
3002392 | 3002392 | 2022-05-24 | US | Texas | Fayette | 48149 | 4830 | 106 | 0 | 29.87788372 | -96.92076062 | 2022-05-25 04:20:56 | Fayette, Texas, US | |
3596113 | 3596113 | 2022-05-23 | US | Texas | Fayette | 48149 | 4830 | 106 | 0 | 29.87788372 | -96.92076062 | 2022-05-24 04:20:57 | Fayette, Texas, US | |
1157759 | 1157759 | 2022-04-29 | US | Colorado | Chaffee | 8015 | 4830 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-04-30 04:21:05 | Chaffee, Colorado, US | |
1157633 | 1157633 | 2022-04-29 | US | Arkansas | Cross | 5037 | 4830 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-04-30 04:21:05 | Cross, Arkansas, US | |
1696815 | 1696815 | 2022-04-28 | US | Arkansas | Cross | 5037 | 4830 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-04-29 04:20:59 | Cross, Arkansas, US | |
3853536 | 3853536 | 2022-04-27 | US | Minnesota | Fillmore | 27045 | 4830 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-04-28 04:20:47 | Fillmore, Minnesota, US | |
3852298 | 3852298 | 2022-04-27 | US | Arkansas | Cross | 5037 | 4830 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-04-28 04:20:47 | Cross, Arkansas, US | |
1326728 | 1326728 | 2022-04-26 | US | Arkansas | Cross | 5037 | 4830 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-04-27 04:20:52 | Cross, Arkansas, US | |
3722682 | 3722682 | 2022-04-25 | US | Arkansas | Cross | 5037 | 4830 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-04-26 04:20:51 | Cross, Arkansas, US | |
2029250 | 2029250 | 2022-04-24 | US | Arkansas | Cross | 5037 | 4830 | 83 | 0 | 35.29631396 | -90.77185818 | 2022-04-25 04:20:56 | Cross, Arkansas, US | |
746825 | 746825 | 2022-04-23 | US | Arkansas | Cross | 5037 | 4830 | 82 | 0 | 35.29631396 | -90.77185818 | 2022-04-24 04:20:56 | Cross, Arkansas, US | |
3437310 | 3437310 | 2022-04-22 | US | Arkansas | Cross | 5037 | 4830 | 82 | 0 | 35.29631396 | -90.77185818 | 2022-04-23 04:20:50 | Cross, Arkansas, US | |
2892895 | 2892895 | 2022-04-21 | US | Arkansas | Cross | 5037 | 4830 | 82 | 0 | 35.29631396 | -90.77185818 | 2022-04-22 04:20:45 | Cross, Arkansas, US | |
2251906 | 2251906 | 2022-04-19 | US | Arkansas | Cross | 5037 | 4830 | 82 | 0 | 35.29631396 | -90.77185818 | 2022-04-20 04:20:45 | Cross, Arkansas, US | |
2443576 | 2443576 | 2022-04-13 | US | Georgia | Hart | 13147 | 4830 | 94 | 0 | 34.34626973 | -82.96567682 | 2022-04-13 23:21:06 | Hart, Georgia, US | |
1543282 | 1543282 | 2022-03-31 | US | Virginia | Colonial Heights | 51570 | 4830 | 96 | 0 | 37.26420587 | -77.39609676 | 2022-04-01 04:20:28 | Colonial Heights, Virginia, US | |
1468920 | 1468920 | 2022-03-24 | US | Georgia | Hart | 13147 | 4830 | 90 | 0 | 34.34626973 | -82.96567682 | 2022-03-25 04:20:46 | Hart, Georgia, US | |
3023094 | 3023094 | 2022-03-23 | US | Georgia | Hart | 13147 | 4830 | 90 | 0 | 34.34626973 | -82.96567682 | 2022-03-24 04:20:43 | Hart, Georgia, US | |
695524 | 695524 | 2022-03-17 | US | Indiana | Rush | 18139 | 4830 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-03-18 04:20:55 | Rush, Indiana, US | |
262425 | 262425 | 2022-03-15 | US | Georgia | Union | 13291 | 4830 | 150 | 0 | 34.82995757 | -83.98967069 | 2022-03-16 04:20:50 | Union, Georgia, US | |
2264994 | 2264994 | 2022-03-14 | US | Indiana | Jay | 18075 | 4830 | 70 | 0 | 40.43781032 | -85.00576229 | 2022-03-15 04:20:47 | Jay, Indiana, US | |
3629060 | 3629060 | 2022-03-13 | US | Indiana | Jay | 18075 | 4830 | 70 | 0 | 40.43781032 | -85.00576229 | 2022-03-14 04:20:46 | Jay, Indiana, US | |
951968 | 951968 | 2022-03-12 | US | Indiana | Jay | 18075 | 4830 | 70 | 0 | 40.43781032 | -85.00576229 | 2022-03-13 04:20:49 | Jay, Indiana, US | |
357429 | 357429 | 2022-03-11 | US | Indiana | Jay | 18075 | 4830 | 70 | 0 | 40.43781032 | -85.00576229 | 2022-03-12 04:20:50 | Jay, Indiana, US | |
1647756 | 1647756 | 2022-03-03 | US | Virginia | Powhatan | 51145 | 4830 | 53 | 0 | 37.55016038 | -77.91267882 | 2022-03-04 04:21:09 | Powhatan, Virginia, US | |
1994224 | 1994224 | 2022-03-01 | US | Maine | Sagadahoc | 23023 | 4830 | 28 | 0 | 43.95415864 | -69.85074999 | 2022-03-02 04:21:07 | Sagadahoc, Maine, US | |
2450203 | 2450203 | 2022-02-22 | US | Washington | Adams | 53001 | 4830 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-23 04:21:09 | Adams, Washington, US | |
2447295 | 2447295 | 2022-02-22 | US | Arkansas | Randolph | 5121 | 4830 | 78 | 0 | 36.3415714 | -91.02455531 | 2022-02-23 04:21:09 | Randolph, Arkansas, US | |
3721616 | 3721616 | 2022-02-21 | US | Washington | Adams | 53001 | 4830 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-22 04:21:01 | Adams, Washington, US | |
3915450 | 3915450 | 2022-02-20 | US | Washington | Adams | 53001 | 4830 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-21 04:21:05 | Adams, Washington, US | |
3879008 | 3879008 | 2022-02-19 | US | Washington | Adams | 53001 | 4830 | 36 | 0 | 46.98299757 | -118.56017340000001 | 2022-02-20 04:21:00 | Adams, Washington, US | |
188338 | 188338 | 2022-02-13 | US | New York | Schoharie | 36095 | 4830 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-02-14 04:20:51 | Schoharie, New York, US | |
1464586 | 1464586 | 2022-02-10 | US | Arkansas | Lincoln | 5079 | 4830 | 60 | 0 | 33.95317155 | -91.74002806 | 2022-02-11 04:21:09 | Lincoln, Arkansas, US | |
2327867 | 2327867 | 2022-02-04 | US | Arkansas | Logan | 5083 | 4830 | 59 | 0 | 35.21413234 | -93.71951016 | 2022-02-05 04:21:05 | Logan, Arkansas, US | |
2474305 | 2474305 | 2022-02-03 | US | Alabama | Butler | 1013 | 4830 | 109 | 0 | 31.75300095 | -86.68057478 | 2022-02-04 04:21:10 | Butler, Alabama, US | |
459730 | 459730 | 2022-02-02 | US | Alabama | Butler | 1013 | 4830 | 109 | 0 | 31.75300095 | -86.68057478 | 2022-02-03 04:21:21 | Butler, Alabama, US | |
1782601 | 1782601 | 2022-01-27 | US | Texas | San Jacinto | 48407 | 4830 | 88 | 0 | 30.57933681 | -95.16260304 | 2022-01-28 04:21:09 | San Jacinto, Texas, US | |
1962221 | 1962221 | 2022-01-20 | US | Michigan | Menominee | 26109 | 4830 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-21 04:21:09 | Menominee, Michigan, US | |
3228116 | 3228116 | 2022-01-19 | US | Michigan | Menominee | 26109 | 4830 | 64 | 0 | 45.58038692 | -87.55370409 | 2022-01-20 04:21:07 | Menominee, Michigan, US | |
3466776 | 3466776 | 2022-01-18 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-19 04:21:23 | Texas, Oklahoma, US | |
1474715 | 1474715 | 2022-01-17 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-18 04:21:04 | Texas, Oklahoma, US | |
557389 | 557389 | 2022-01-16 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-17 04:21:08 | Texas, Oklahoma, US | |
3843110 | 3843110 | 2022-01-15 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-16 04:21:12 | Texas, Oklahoma, US | |
101925 | 101925 | 2022-01-14 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-15 04:21:07 | Texas, Oklahoma, US | |
3690080 | 3690080 | 2022-01-13 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-14 04:21:54 | Texas, Oklahoma, US | |
3615664 | 3615664 | 2022-01-12 | US | Oklahoma | Texas | 40139 | 4830 | 44 | 0 | 36.74777635 | -101.4889765 | 2022-01-13 08:00:09 | Texas, Oklahoma, US | |
1693426 | 1693426 | 2022-01-10 | US | Indiana | LaGrange | 18087 | 4830 | 95 | 0 | 41.64232188 | -85.42674232 | 2022-01-11 04:22:01 | LaGrange, Indiana, 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]);