johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
308 rows where confirmed = 2285 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754355 | 2754355 | 2022-12-29 | US | Kentucky | Menifee | 21165 | 2285 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-30 04:21:04 | Menifee, Kentucky, US | |
2754054 | 2754054 | 2022-12-29 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-30 04:21:04 | Union, Indiana, US | |
1075361 | 1075361 | 2022-12-28 | US | Kentucky | Menifee | 21165 | 2285 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-29 04:21:01 | Menifee, Kentucky, US | |
1075060 | 1075060 | 2022-12-28 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-29 04:21:01 | Union, Indiana, US | |
329358 | 329358 | 2022-12-27 | US | Kentucky | Menifee | 21165 | 2285 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-28 04:21:04 | Menifee, Kentucky, US | |
329057 | 329057 | 2022-12-27 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-28 04:21:04 | Union, Indiana, US | |
219130 | 219130 | 2022-12-26 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-27 04:21:07 | Union, Indiana, US | |
3223587 | 3223587 | 2022-12-25 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-26 04:21:06 | Union, Indiana, US | |
3222950 | 3222950 | 2022-12-25 | US | Arkansas | Monroe | 5095 | 2285 | 38 | 0 | 34.6815935 | -91.20540287 | 2022-12-26 04:21:06 | Monroe, Arkansas, US | |
1019501 | 1019501 | 2022-12-24 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-25 04:21:04 | Union, Indiana, US | |
1018864 | 1018864 | 2022-12-24 | US | Arkansas | Monroe | 5095 | 2285 | 38 | 0 | 34.6815935 | -91.20540287 | 2022-12-25 04:21:04 | Monroe, Arkansas, US | |
691524 | 691524 | 2022-12-23 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-24 04:21:02 | Union, Indiana, US | |
2180734 | 2180734 | 2022-12-22 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-23 04:21:04 | Union, Indiana, US | |
452538 | 452538 | 2022-12-21 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-22 04:20:56 | Union, Indiana, US | |
2952537 | 2952537 | 2022-12-20 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-21 04:21:03 | Union, Indiana, US | |
3174939 | 3174939 | 2022-12-19 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-20 04:21:04 | Union, Indiana, US | |
1629456 | 1629456 | 2022-12-18 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-19 04:21:03 | Union, Indiana, US | |
504835 | 504835 | 2022-12-17 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-18 04:21:03 | Union, Indiana, US | |
3325407 | 3325407 | 2022-12-16 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-17 04:21:04 | Union, Indiana, US | |
543919 | 543919 | 2022-12-15 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-16 04:21:01 | Union, Indiana, US | |
349447 | 349447 | 2022-12-14 | US | Indiana | Union | 18161 | 2285 | 23 | 0 | 39.62550777 | -84.92497066 | 2022-12-15 04:20:58 | Union, Indiana, US | |
1831309 | 1831309 | 2022-10-25 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-26 04:22:19 | Warren, Indiana, US | |
795570 | 795570 | 2022-10-24 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-25 04:21:53 | Warren, Indiana, US | |
3278025 | 3278025 | 2022-10-23 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-24 04:22:29 | Warren, Indiana, US | |
2269063 | 2269063 | 2022-10-22 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-23 04:22:46 | Warren, Indiana, US | |
1593363 | 1593363 | 2022-10-21 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-22 04:22:53 | Warren, Indiana, US | |
2273079 | 2273079 | 2022-10-20 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-21 04:22:23 | Warren, Indiana, US | |
199414 | 199414 | 2022-10-19 | US | Indiana | Warren | 18171 | 2285 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-10-20 04:22:59 | Warren, Indiana, US | |
2529906 | 2529906 | 2022-10-06 | US | Arkansas | Prairie | 5117 | 2285 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-10-07 04:23:08 | Prairie, Arkansas, US | |
2261951 | 2261951 | 2022-10-02 | US | New Jersey | Unassigned | 90034 | 2285 | 0 | 0 | 41.13891592 | 0.0 | 2022-10-03 04:23:11 | Unassigned, New Jersey, US | |
1977547 | 1977547 | 2022-09-25 | US | Idaho | Boundary | 16021 | 2285 | 67 | 0 | 48.76684761 | -116.4630179 | 2022-09-26 04:20:52 | Boundary, Idaho, US | |
2650714 | 2650714 | 2022-09-24 | US | Idaho | Boundary | 16021 | 2285 | 67 | 0 | 48.76684761 | -116.4630179 | 2022-09-25 04:23:31 | Boundary, Idaho, US | |
385154 | 385154 | 2022-09-23 | US | Idaho | Boundary | 16021 | 2285 | 67 | 0 | 48.76684761 | -116.4630179 | 2022-09-24 04:21:40 | Boundary, Idaho, US | |
253102 | 253102 | 2022-09-08 | China | Guangxi | 2285 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-09 04:21:11 | Guangxi, China | |||
1880054 | 1880054 | 2022-08-28 | US | Texas | Dallam | 48111 | 2285 | 42 | 0 | 36.27787176 | -102.6020725 | 2022-08-29 04:21:06 | Dallam, Texas, US | |
1879151 | 1879151 | 2022-08-28 | US | New Hampshire | Unassigned | 90033 | 2285 | 6 | 0 | 44.69063265 | 0.0 | 2022-08-29 04:21:06 | Unassigned, New Hampshire, US | |
2099181 | 2099181 | 2022-08-27 | US | Texas | Dallam | 48111 | 2285 | 42 | 0 | 36.27787176 | -102.6020725 | 2022-08-28 04:21:02 | Dallam, Texas, US | |
2098278 | 2098278 | 2022-08-27 | US | New Hampshire | Unassigned | 90033 | 2285 | 6 | 0 | 44.69063265 | 0.0 | 2022-08-28 04:21:02 | Unassigned, New Hampshire, US | |
1534996 | 1534996 | 2022-08-26 | US | Texas | Dallam | 48111 | 2285 | 42 | 0 | 36.27787176 | -102.6020725 | 2022-08-27 04:20:57 | Dallam, Texas, US | |
1534093 | 1534093 | 2022-08-26 | US | New Hampshire | Unassigned | 90033 | 2285 | 6 | 0 | 44.69063265 | 0.0 | 2022-08-27 04:20:57 | Unassigned, New Hampshire, US | |
2832323 | 2832323 | 2022-08-25 | US | West Virginia | Pleasants | 54073 | 2285 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-08-26 04:21:02 | Pleasants, West Virginia, US | |
2829862 | 2829862 | 2022-08-25 | US | Illinois | Schuyler | 17169 | 2285 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-08-26 04:21:02 | Schuyler, Illinois, US | |
1072328 | 1072328 | 2022-08-07 | US | North Dakota | Traill | 38097 | 2285 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-08-08 04:21:08 | Traill, North Dakota, US | |
1942916 | 1942916 | 2022-08-06 | US | North Dakota | Traill | 38097 | 2285 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-08-07 04:20:54 | Traill, North Dakota, US | |
1408094 | 1408094 | 2022-08-02 | US | Texas | Clay | 48077 | 2285 | 39 | 0 | 33.78686685 | -98.20771198 | 2022-08-03 04:20:59 | Clay, Texas, US | |
3617608 | 3617608 | 2022-08-01 | US | Arkansas | Searcy | 5129 | 2285 | 49 | 0 | 35.9109364 | -92.69936482 | 2022-08-02 04:20:53 | Searcy, Arkansas, US | |
3873776 | 3873776 | 2022-07-31 | US | New Mexico | Sierra | 35051 | 2285 | 82 | 0 | 33.13028233 | -107.1925893 | 2022-08-01 04:21:03 | Sierra, New Mexico, US | |
676530 | 676530 | 2022-07-30 | US | New Mexico | Sierra | 35051 | 2285 | 82 | 0 | 33.13028233 | -107.1925893 | 2022-07-31 04:21:02 | Sierra, New Mexico, US | |
1785729 | 1785729 | 2022-07-29 | US | New Mexico | Sierra | 35051 | 2285 | 82 | 0 | 33.13028233 | -107.1925893 | 2022-07-30 04:20:42 | Sierra, New Mexico, US | |
2594431 | 2594431 | 2022-07-25 | US | Alabama | Perry | 1105 | 2285 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-07-26 04:20:58 | Perry, Alabama, US | |
631182 | 631182 | 2022-07-12 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-13 04:20:58 | Cloud, Kansas, US | |
1212826 | 1212826 | 2022-07-11 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-12 04:20:51 | Cloud, Kansas, US | |
2790308 | 2790308 | 2022-07-10 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-11 04:20:46 | Cloud, Kansas, US | |
143261 | 143261 | 2022-07-09 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-10 04:20:54 | Cloud, Kansas, US | |
1418361 | 1418361 | 2022-07-08 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-09 04:20:59 | Cloud, Kansas, US | |
2742286 | 2742286 | 2022-07-07 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-08 04:20:56 | Cloud, Kansas, US | |
1201081 | 1201081 | 2022-07-06 | US | Kansas | Cloud | 20029 | 2285 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-07 04:20:55 | Cloud, Kansas, US | |
2190592 | 2190592 | 2022-06-22 | US | Tennessee | Moore | 47127 | 2285 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-06-23 04:20:55 | Moore, Tennessee, US | |
971395 | 971395 | 2022-06-01 | US | Arkansas | Cleveland | 5025 | 2285 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-06-02 05:20:39 | Cleveland, Arkansas, US | |
2087292 | 2087292 | 2022-05-15 | US | Virginia | Essex | 51057 | 2285 | 33 | 0 | 37.93357639 | -76.94230311 | 2022-05-16 04:20:47 | Essex, Virginia, US | |
3358002 | 3358002 | 2022-05-14 | US | Virginia | Essex | 51057 | 2285 | 33 | 0 | 37.93357639 | -76.94230311 | 2022-05-15 04:20:53 | Essex, Virginia, US | |
661647 | 661647 | 2022-05-13 | US | Virginia | Essex | 51057 | 2285 | 33 | 0 | 37.93357639 | -76.94230311 | 2022-05-14 04:20:48 | Essex, Virginia, US | |
225225 | 225225 | 2022-05-09 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-10 04:20:50 | Swisher, Texas, US | |
2334610 | 2334610 | 2022-05-08 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-09 04:20:54 | Swisher, Texas, US | |
363572 | 363572 | 2022-05-07 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-08 04:20:49 | Swisher, Texas, US | |
1400923 | 1400923 | 2022-05-06 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-07 04:21:09 | Swisher, Texas, US | |
2601278 | 2601278 | 2022-05-05 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-06 04:21:00 | Swisher, Texas, US | |
3268727 | 3268727 | 2022-05-04 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-05 04:20:55 | Swisher, Texas, US | |
3268271 | 3268271 | 2022-05-04 | US | Puerto Rico | Rincon | 72117 | 2285 | 0 | 0 | 18.335443 | -67.23174 | 2022-05-05 04:20:55 | Rincon, Puerto Rico, US | |
1575366 | 1575366 | 2022-05-03 | US | Texas | Swisher | 48437 | 2285 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-05-04 04:20:59 | Swisher, Texas, US | |
1541730 | 1541730 | 2022-03-31 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-04-01 04:20:28 | Swift, Minnesota, US | |
2480730 | 2480730 | 2022-03-30 | US | Puerto Rico | Luquillo | 72089 | 2285 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-03-31 04:20:56 | Luquillo, Puerto Rico, US | |
2479743 | 2479743 | 2022-03-30 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-03-31 04:20:56 | Swift, Minnesota, US | |
161223 | 161223 | 2022-03-29 | US | Texas | Runnels | 48399 | 2285 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-03-30 04:20:45 | Runnels, Texas, US | |
160771 | 160771 | 2022-03-29 | US | Puerto Rico | Luquillo | 72089 | 2285 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-03-30 04:20:45 | Luquillo, Puerto Rico, US | |
159784 | 159784 | 2022-03-29 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-03-30 04:20:45 | Swift, Minnesota, US | |
1439794 | 1439794 | 2022-03-28 | US | Texas | Runnels | 48399 | 2285 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-03-29 04:20:46 | Runnels, Texas, US | |
1439342 | 1439342 | 2022-03-28 | US | Puerto Rico | Luquillo | 72089 | 2285 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-03-29 04:20:46 | Luquillo, Puerto Rico, US | |
1438355 | 1438355 | 2022-03-28 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-03-29 04:20:46 | Swift, Minnesota, US | |
879475 | 879475 | 2022-03-27 | US | Texas | Runnels | 48399 | 2285 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-03-28 04:20:33 | Runnels, Texas, US | |
879023 | 879023 | 2022-03-27 | US | Puerto Rico | Luquillo | 72089 | 2285 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-03-28 04:20:33 | Luquillo, Puerto Rico, US | |
878036 | 878036 | 2022-03-27 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-03-28 04:20:33 | Swift, Minnesota, US | |
2166758 | 2166758 | 2022-03-26 | US | Texas | Runnels | 48399 | 2285 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-03-27 04:20:47 | Runnels, Texas, US | |
2165319 | 2165319 | 2022-03-26 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-03-27 04:20:47 | Swift, Minnesota, US | |
1723694 | 1723694 | 2022-03-25 | US | Texas | Runnels | 48399 | 2285 | 66 | 0 | 31.8314342 | -99.97616148 | 2022-03-26 04:20:23 | Runnels, Texas, US | |
1722255 | 1722255 | 2022-03-25 | US | Minnesota | Swift | 27151 | 2285 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-03-26 04:20:23 | Swift, Minnesota, US | |
3238852 | 3238852 | 2022-03-21 | US | Arkansas | Scott | 5127 | 2285 | 41 | 0 | 34.85588887 | -94.0632176 | 2022-03-22 04:20:54 | Scott, Arkansas, US | |
24925 | 24925 | 2022-03-20 | US | Arkansas | Scott | 5127 | 2285 | 41 | 0 | 34.85588887 | -94.0632176 | 2022-03-21 04:20:50 | Scott, Arkansas, US | |
1656935 | 1656935 | 2022-03-19 | US | Arkansas | Scott | 5127 | 2285 | 41 | 0 | 34.85588887 | -94.0632176 | 2022-03-20 04:20:45 | Scott, Arkansas, US | |
2322537 | 2322537 | 2022-03-16 | US | Texas | Red River | 48387 | 2285 | 64 | 0 | 33.61886692 | -95.04841765 | 2022-03-17 04:20:56 | Red River, Texas, US | |
2320266 | 2320266 | 2022-03-16 | US | Idaho | Clearwater | 16035 | 2285 | 32 | 0 | 46.67459924 | -115.6622393 | 2022-03-17 04:20:56 | Clearwater, Idaho, US | |
922612 | 922612 | 2022-03-08 | US | Tennessee | Clay | 47027 | 2285 | 47 | 0 | 36.55151008 | -85.53930419 | 2022-03-09 04:20:59 | Clay, Tennessee, US | |
1550899 | 1550899 | 2022-03-07 | US | Tennessee | Clay | 47027 | 2285 | 47 | 0 | 36.55151008 | -85.53930419 | 2022-03-08 04:20:54 | Clay, Tennessee, US | |
2091913 | 2091913 | 2022-03-05 | China | Zhejiang | 2285 | 1 | 0 | 29.1832 | 120.0934 | 2022-03-06 04:20:49 | Zhejiang, China | |||
1514558 | 1514558 | 2022-02-24 | US | Texas | La Salle | 48283 | 2285 | 45 | 0 | 28.34453111 | -99.09908775 | 2022-02-25 04:21:11 | La Salle, Texas, US | |
1300047 | 1300047 | 2022-02-17 | US | Montana | Dawson | 30021 | 2285 | 54 | 0 | 47.26584855 | -104.89444170000002 | 2022-02-18 04:21:04 | Dawson, Montana, US | |
2645145 | 2645145 | 2022-02-14 | US | Virginia | Poquoson | 51735 | 2285 | 27 | 0 | 37.14259351 | -76.35798148 | 2022-02-15 04:21:09 | Poquoson, Virginia, US | |
187007 | 187007 | 2022-02-13 | US | Idaho | Franklin | 16041 | 2285 | 27 | 0 | 42.18332217 | -111.81496659999999 | 2022-02-14 04:20:51 | Franklin, Idaho, US | |
316853 | 316853 | 2022-02-12 | US | Idaho | Franklin | 16041 | 2285 | 27 | 0 | 42.18332217 | -111.81496659999999 | 2022-02-13 04:21:00 | Franklin, Idaho, US | |
234179 | 234179 | 2022-02-11 | US | Idaho | Franklin | 16041 | 2285 | 27 | 0 | 42.18332217 | -111.81496659999999 | 2022-02-12 04:21:06 | Franklin, Idaho, 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]);