johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
223 rows where confirmed = 3324 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3461185 | 3461185 | 2022-11-21 | US | Illinois | Marshall | 17123 | 3324 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-11-22 04:20:47 | Marshall, Illinois, US | |
1889792 | 1889792 | 2022-09-14 | US | Colorado | Park | 8093 | 3324 | 22 | 0 | 39.120926 | -105.7182065 | 2022-09-15 04:21:02 | Park, Colorado, US | |
373141 | 373141 | 2022-09-13 | US | Idaho | Idaho | 16049 | 3324 | 55 | 0 | 45.84721541 | -115.4634436 | 2022-09-14 04:20:44 | Idaho, Idaho, US | |
373082 | 373082 | 2022-09-13 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-14 04:20:44 | Telfair, Georgia, US | |
372847 | 372847 | 2022-09-13 | US | Colorado | Park | 8093 | 3324 | 22 | 0 | 39.120926 | -105.7182065 | 2022-09-14 04:20:44 | Park, Colorado, US | |
2395743 | 2395743 | 2022-09-12 | US | Idaho | Idaho | 16049 | 3324 | 55 | 0 | 45.84721541 | -115.4634436 | 2022-09-13 04:20:57 | Idaho, Idaho, US | |
2395684 | 2395684 | 2022-09-12 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-13 04:20:57 | Telfair, Georgia, US | |
3766762 | 3766762 | 2022-09-11 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-12 04:20:58 | Telfair, Georgia, US | |
3825337 | 3825337 | 2022-09-10 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-11 04:20:50 | Telfair, Georgia, US | |
963794 | 963794 | 2022-09-09 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-10 04:21:10 | Telfair, Georgia, US | |
254196 | 254196 | 2022-09-08 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-09 04:21:11 | Telfair, Georgia, US | |
3745994 | 3745994 | 2022-09-07 | US | Georgia | Telfair | 13271 | 3324 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-09-08 04:21:02 | Telfair, Georgia, US | |
1073082 | 1073082 | 2022-08-07 | US | Texas | Nolan | 48353 | 3324 | 100 | 0 | 32.30365282 | -100.4060208 | 2022-08-08 04:21:08 | Nolan, Texas, US | |
1943670 | 1943670 | 2022-08-06 | US | Texas | Nolan | 48353 | 3324 | 100 | 0 | 32.30365282 | -100.4060208 | 2022-08-07 04:20:54 | Nolan, Texas, US | |
883469 | 883469 | 2022-08-05 | US | Texas | Nolan | 48353 | 3324 | 100 | 0 | 32.30365282 | -100.4060208 | 2022-08-06 04:20:56 | Nolan, Texas, US | |
2011880 | 2011880 | 2022-08-04 | US | Texas | Nolan | 48353 | 3324 | 100 | 0 | 32.30365282 | -100.4060208 | 2022-08-05 04:20:52 | Nolan, Texas, US | |
3872202 | 3872202 | 2022-07-31 | US | Colorado | Moffat | 8081 | 3324 | 53 | 0 | 40.61810999 | -108.2070876 | 2022-08-01 04:21:03 | Moffat, Colorado, US | |
674956 | 674956 | 2022-07-30 | US | Colorado | Moffat | 8081 | 3324 | 53 | 0 | 40.61810999 | -108.2070876 | 2022-07-31 04:21:02 | Moffat, Colorado, US | |
1489151 | 1489151 | 2022-07-26 | US | Maine | Piscataquis | 23021 | 3324 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-07-27 04:21:04 | Piscataquis, Maine, US | |
3349050 | 3349050 | 2022-06-24 | US | North Dakota | McKenzie | 38053 | 3324 | 25 | 0 | 47.7413337 | -103.395905 | 2022-06-25 04:20:57 | McKenzie, North Dakota, US | |
561223 | 561223 | 2022-06-16 | US | North Dakota | Mountrail | 38061 | 3324 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-06-17 04:20:56 | Mountrail, North Dakota, US | |
1111696 | 1111696 | 2022-05-21 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-22 04:20:52 | Seward, Nebraska, US | |
1171320 | 1171320 | 2022-05-20 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-21 04:20:58 | Seward, Nebraska, US | |
3898083 | 3898083 | 2022-05-19 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-20 04:20:57 | Seward, Nebraska, US | |
1186867 | 1186867 | 2022-05-18 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-19 04:20:54 | Seward, Nebraska, US | |
3584764 | 3584764 | 2022-05-17 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-18 04:20:50 | Seward, Nebraska, US | |
1505721 | 1505721 | 2022-05-16 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-17 04:20:59 | Seward, Nebraska, US | |
2086080 | 2086080 | 2022-05-15 | US | Nebraska | Seward | 31159 | 3324 | 42 | 0 | 40.87241834 | -97.139673 | 2022-05-16 04:20:47 | Seward, Nebraska, US | |
2894598 | 2894598 | 2022-04-21 | US | New Jersey | Unassigned | 90034 | 3324 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-22 04:20:45 | Unassigned, New Jersey, US | |
2310636 | 2310636 | 2022-04-20 | US | Virginia | Greensville | 51081 | 3324 | 39 | 0 | 36.67878901 | -77.56351439 | 2022-04-21 04:20:46 | Greensville, Virginia, US | |
2309470 | 2309470 | 2022-04-20 | US | New Jersey | Unassigned | 90034 | 3324 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-21 04:20:46 | Unassigned, New Jersey, US | |
1849325 | 1849325 | 2022-04-18 | US | Virginia | Greensville | 51081 | 3324 | 39 | 0 | 36.67878901 | -77.56351439 | 2022-04-19 04:21:00 | Greensville, Virginia, US | |
2671997 | 2671997 | 2022-04-15 | US | New Jersey | Unassigned | 90034 | 3324 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-16 04:20:48 | Unassigned, New Jersey, US | |
1951863 | 1951863 | 2022-04-12 | US | Virginia | Greensville | 51081 | 3324 | 39 | 0 | 36.67878901 | -77.56351439 | 2022-04-13 04:21:03 | Greensville, Virginia, US | |
3321555 | 3321555 | 2022-04-07 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-08 04:20:48 | Marion, Kansas, US | |
2802091 | 2802091 | 2022-04-06 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-07 04:20:53 | Marion, Kansas, US | |
3868860 | 3868860 | 2022-04-05 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-06 04:20:49 | Marion, Kansas, US | |
2750202 | 2750202 | 2022-04-04 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-05 04:20:48 | Marion, Kansas, US | |
3732417 | 3732417 | 2022-04-03 | US | New Jersey | Unassigned | 90034 | 3324 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-04 04:20:51 | Unassigned, New Jersey, US | |
3731548 | 3731548 | 2022-04-03 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-04 04:20:51 | Marion, Kansas, US | |
501852 | 501852 | 2022-04-02 | US | New Jersey | Unassigned | 90034 | 3324 | 0 | 0 | 41.13891592 | 0.0 | 2022-04-03 04:20:48 | Unassigned, New Jersey, US | |
500983 | 500983 | 2022-04-02 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-03 04:20:48 | Marion, Kansas, US | |
3351968 | 3351968 | 2022-04-01 | US | Kansas | Marion | 20115 | 3324 | 43 | 0 | 38.35855394 | -97.09852509999999 | 2022-04-02 04:20:47 | Marion, Kansas, US | |
159327 | 159327 | 2022-03-29 | US | Kansas | Marion | 20115 | 3324 | 40 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-30 04:20:45 | Marion, Kansas, US | |
1437898 | 1437898 | 2022-03-28 | US | Kansas | Marion | 20115 | 3324 | 40 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-29 04:20:46 | Marion, Kansas, US | |
879676 | 879676 | 2022-03-27 | US | Virginia | Southampton | 51175 | 3324 | 89 | 0 | 36.72231125 | -77.10642712 | 2022-03-28 04:20:33 | Southampton, Virginia, US | |
878880 | 878880 | 2022-03-27 | US | Oregon | Curry | 41015 | 3324 | 50 | 0 | 42.45911325 | -124.15728200000001 | 2022-03-28 04:20:33 | Curry, Oregon, US | |
877579 | 877579 | 2022-03-27 | US | Kansas | Marion | 20115 | 3324 | 40 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-28 04:20:33 | Marion, Kansas, US | |
2166959 | 2166959 | 2022-03-26 | US | Virginia | Southampton | 51175 | 3324 | 89 | 0 | 36.72231125 | -77.10642712 | 2022-03-27 04:20:47 | Southampton, Virginia, US | |
2166163 | 2166163 | 2022-03-26 | US | Oregon | Curry | 41015 | 3324 | 50 | 0 | 42.45911325 | -124.15728200000001 | 2022-03-27 04:20:47 | Curry, Oregon, US | |
2164862 | 2164862 | 2022-03-26 | US | Kansas | Marion | 20115 | 3324 | 40 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-27 04:20:47 | Marion, Kansas, US | |
1723895 | 1723895 | 2022-03-25 | US | Virginia | Southampton | 51175 | 3324 | 89 | 0 | 36.72231125 | -77.10642712 | 2022-03-26 04:20:23 | Southampton, Virginia, US | |
1723099 | 1723099 | 2022-03-25 | US | Oregon | Curry | 41015 | 3324 | 50 | 0 | 42.45911325 | -124.15728200000001 | 2022-03-26 04:20:23 | Curry, Oregon, US | |
1721798 | 1721798 | 2022-03-25 | US | Kansas | Marion | 20115 | 3324 | 40 | 0 | 38.35855394 | -97.09852509999999 | 2022-03-26 04:20:23 | Marion, Kansas, US | |
1471512 | 1471512 | 2022-03-24 | US | Virginia | Southampton | 51175 | 3324 | 89 | 0 | 36.72231125 | -77.10642712 | 2022-03-25 04:20:46 | Southampton, Virginia, US | |
3024890 | 3024890 | 2022-03-23 | US | Oregon | Curry | 41015 | 3324 | 49 | 0 | 42.45911325 | -124.15728200000001 | 2022-03-24 04:20:43 | Curry, Oregon, US | |
3240943 | 3240943 | 2022-03-21 | US | Oregon | Curry | 41015 | 3324 | 47 | 0 | 42.45911325 | -124.15728200000001 | 2022-03-22 04:20:54 | Curry, Oregon, US | |
697466 | 697466 | 2022-03-17 | US | Texas | Duval | 48131 | 3324 | 68 | 0 | 27.68184592 | -98.50864568 | 2022-03-18 04:20:55 | Duval, Texas, US | |
2322409 | 2322409 | 2022-03-16 | US | Texas | Duval | 48131 | 3324 | 68 | 0 | 27.68184592 | -98.50864568 | 2022-03-17 04:20:56 | Duval, Texas, US | |
2266609 | 2266609 | 2022-03-14 | US | Puerto Rico | Aibonito | 72009 | 3324 | 0 | 0 | 18.131361 | -66.264131 | 2022-03-15 04:20:47 | Aibonito, Puerto Rico, US | |
3630675 | 3630675 | 2022-03-13 | US | Puerto Rico | Aibonito | 72009 | 3324 | 0 | 0 | 18.131361 | -66.264131 | 2022-03-14 04:20:46 | Aibonito, Puerto Rico, US | |
2142108 | 2142108 | 2022-03-09 | US | Missouri | Mississippi | 29133 | 3324 | 56 | 0 | 36.82516239 | -89.29505753 | 2022-03-10 04:20:48 | Mississippi, Missouri, US | |
1646469 | 1646469 | 2022-03-03 | US | Nebraska | Otoe | 31131 | 3324 | 10 | 0 | 40.64843556 | -96.13374142 | 2022-03-04 04:21:09 | Otoe, Nebraska, US | |
1364974 | 1364974 | 2022-02-08 | US | Oregon | Hood River | 41027 | 3324 | 41 | 0 | 45.51872811 | -121.65520359999998 | 2022-02-09 04:21:04 | Hood River, Oregon, US | |
979698 | 979698 | 2022-02-01 | US | Georgia | Bacon | 13005 | 3324 | 65 | 0 | 31.55456473 | -82.45936528 | 2022-02-02 04:21:09 | Bacon, Georgia, US | |
3301233 | 3301233 | 2022-01-30 | US | Illinois | Menard | 17129 | 3324 | 18 | 0 | 40.02742725 | -89.80246001 | 2022-01-31 04:21:09 | Menard, Illinois, US | |
3063024 | 3063024 | 2022-01-29 | US | Illinois | Menard | 17129 | 3324 | 18 | 0 | 40.02742725 | -89.80246001 | 2022-01-30 04:21:26 | Menard, Illinois, US | |
3810958 | 3810958 | 2022-01-28 | US | Illinois | Menard | 17129 | 3324 | 18 | 0 | 40.02742725 | -89.80246001 | 2022-01-29 04:21:10 | Menard, Illinois, US | |
2053270 | 2053270 | 2022-01-25 | US | Kentucky | Casey | 21045 | 3324 | 65 | 0 | 37.32533118 | -84.92726209 | 2022-01-26 04:21:07 | Casey, Kentucky, US | |
3467337 | 3467337 | 2022-01-18 | US | Texas | Llano | 48299 | 3324 | 87 | 0 | 30.70645047 | -98.68475262 | 2022-01-19 04:21:23 | Llano, Texas, US | |
1472610 | 1472610 | 2022-01-17 | US | Arkansas | Izard | 5065 | 3324 | 60 | 0 | 36.09604046 | -91.90847954 | 2022-01-18 04:21:04 | Izard, Arkansas, US | |
2610647 | 2610647 | 2022-01-06 | US | Colorado | Alamosa | 8003 | 3324 | 58 | 0 | 37.57250606 | -105.7885451 | 2022-01-07 04:22:09 | Alamosa, Colorado, US | |
3521925 | 3521925 | 2022-01-02 | US | Ohio | Meigs | 39105 | 3324 | 73 | 0 | 39.09224872 | -82.0305041 | 2022-01-03 02:22:25 | Meigs, Ohio, US | |
1433754 | 1433754 | 2021-12-28 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-29 03:21:43 | Dickinson, Iowa, US | |
734054 | 734054 | 2021-12-27 | US | Wisconsin | Adams | 55001 | 3324 | 39 | 0 | 43.96974651 | -89.76782777 | 2021-12-28 04:21:47 | Adams, Wisconsin, US | |
733707 | 733707 | 2021-12-27 | US | Texas | Montague | 48337 | 3324 | 99 | 0 | 33.67521893 | -97.72500958 | 2021-12-28 04:21:47 | Montague, Texas, US | |
731715 | 731715 | 2021-12-27 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-28 04:21:47 | Dickinson, Iowa, US | |
2115226 | 2115226 | 2021-12-26 | US | Wisconsin | Adams | 55001 | 3324 | 39 | 0 | 43.96974651 | -89.76782777 | 2021-12-27 04:21:58 | Adams, Wisconsin, US | |
2112887 | 2112887 | 2021-12-26 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-27 04:21:58 | Dickinson, Iowa, US | |
3608598 | 3608598 | 2021-12-25 | US | Wisconsin | Adams | 55001 | 3324 | 39 | 0 | 43.96974651 | -89.76782777 | 2021-12-26 04:21:50 | Adams, Wisconsin, US | |
3606259 | 3606259 | 2021-12-25 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-26 04:21:50 | Dickinson, Iowa, US | |
2966916 | 2966916 | 2021-12-24 | US | Wisconsin | Adams | 55001 | 3324 | 39 | 0 | 43.96974651 | -89.76782777 | 2021-12-25 04:21:37 | Adams, Wisconsin, US | |
2966583 | 2966583 | 2021-12-24 | US | Texas | Panola | 48365 | 3324 | 111 | 0 | 32.163959600000005 | -94.30552481 | 2021-12-25 04:21:37 | Panola, Texas, US | |
2964577 | 2964577 | 2021-12-24 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-25 04:21:37 | Dickinson, Iowa, US | |
3817609 | 3817609 | 2021-12-23 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-24 04:21:34 | Dickinson, Iowa, US | |
799617 | 799617 | 2021-12-22 | US | Iowa | Dickinson | 19059 | 3324 | 60 | 0 | 43.37787725 | -95.1510206 | 2021-12-23 04:21:21 | Dickinson, Iowa, US | |
1256491 | 1256491 | 2021-12-20 | US | Minnesota | Fillmore | 27045 | 3324 | 15 | 0 | 43.67394126 | -92.08980382 | 2021-12-21 03:21:27 | Fillmore, Minnesota, US | |
2089737 | 2089737 | 2021-12-14 | US | Minnesota | Roseau | 27135 | 3324 | 33 | 0 | 48.77501878 | -95.81079919 | 2021-12-15 03:22:16 | Roseau, Minnesota, US | |
1665085 | 1665085 | 2021-12-11 | US | Colorado | Otero | 8089 | 3324 | 116 | 0 | 37.9014485 | -103.7173385 | 2021-12-12 04:22:12 | Otero, Colorado, US | |
3656237 | 3656237 | 2021-12-10 | US | Colorado | Otero | 8089 | 3324 | 116 | 0 | 37.9014485 | -103.7173385 | 2021-12-11 04:22:45 | Otero, Colorado, US | |
1081143 | 1081143 | 2021-12-09 | US | Texas | Scurry | 48415 | 3324 | 85 | 0 | 32.74613808 | -100.91626640000001 | 2021-12-10 04:22:28 | Scurry, Texas, US | |
1740326 | 1740326 | 2021-12-05 | China | Guangdong | 3324 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-06 04:22:34 | Guangdong, China | |||
29214 | 29214 | 2021-11-11 | US | Georgia | Elbert | 13105 | 3324 | 88 | 0 | 34.11302332 | -82.83936148 | 2021-11-12 04:22:01 | Elbert, Georgia, US | |
2845653 | 2845653 | 2021-11-10 | US | Georgia | Elbert | 13105 | 3324 | 88 | 0 | 34.11302332 | -82.83936148 | 2021-11-11 04:21:45 | Elbert, Georgia, US | |
3640642 | 3640642 | 2021-11-08 | US | Indiana | Fulton | 18049 | 3324 | 69 | 0 | 41.0469907 | -86.26252745 | 2021-11-09 04:21:36 | Fulton, Indiana, US | |
3512385 | 3512385 | 2021-11-01 | US | Illinois | Douglas | 17041 | 3324 | 38 | 0 | 39.76768052 | -88.21854195 | 2021-11-02 04:22:03 | Douglas, Illinois, US | |
3493313 | 3493313 | 2021-10-26 | US | Indiana | Sullivan | 18153 | 3324 | 52 | 0 | 39.08952258 | -87.41414469 | 2021-10-27 04:22:32 | Sullivan, Indiana, US | |
444331 | 444331 | 2021-10-20 | US | Illinois | Crawford | 17033 | 3324 | 30 | 0 | 39.0032229 | -87.75954624 | 2021-10-21 04:21:18 | Crawford, Illinois, US | |
426822 | 426822 | 2021-10-10 | US | West Virginia | Boone | 54005 | 3324 | 44 | 0 | 38.01974191 | -81.69888019 | 2021-10-11 04:21:31 | Boone, West Virginia, US | |
3833655 | 3833655 | 2021-10-05 | US | Iowa | Carroll | 19027 | 3324 | 53 | 0 | 42.03617207 | -94.86032705 | 2021-10-06 04:21:33 | Carroll, Iowa, 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]);