johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
518 rows where confirmed = 737 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
293367 | 293367 | 2022-11-15 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-16 04:21:09 | Smith, Kansas, US | |
3598397 | 3598397 | 2022-11-14 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-15 04:21:16 | Smith, Kansas, US | |
313255 | 313255 | 2022-11-13 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-14 04:21:09 | Smith, Kansas, US | |
64416 | 64416 | 2022-11-12 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-13 04:21:14 | Smith, Kansas, US | |
2928578 | 2928578 | 2022-11-11 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-12 04:20:41 | Smith, Kansas, US | |
2507414 | 2507414 | 2022-11-10 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-11 04:21:22 | Smith, Kansas, US | |
2432289 | 2432289 | 2022-11-09 | US | Kansas | Smith | 20183 | 737 | 9 | 0 | 39.78516566 | -98.78566062 | 2022-11-10 04:21:16 | Smith, Kansas, US | |
3873973 | 3873973 | 2022-07-31 | US | North Dakota | McIntosh | 38051 | 737 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-08-01 04:21:03 | McIntosh, North Dakota, US | |
676727 | 676727 | 2022-07-30 | US | North Dakota | McIntosh | 38051 | 737 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-07-31 04:21:02 | McIntosh, North Dakota, US | |
1785926 | 1785926 | 2022-07-29 | US | North Dakota | McIntosh | 38051 | 737 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-07-30 04:20:42 | McIntosh, North Dakota, US | |
3109272 | 3109272 | 2022-07-13 | China | Gansu | 737 | 2 | 0 | 35.7518 | 104.2861 | 2022-07-14 04:20:57 | Gansu, China | |||
2792194 | 2792194 | 2022-07-10 | US | Texas | Lipscomb | 48295 | 737 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-07-11 04:20:46 | Lipscomb, Texas, US | |
3941993 | 3941993 | 2022-06-30 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-07-01 04:21:10 | Mercer, Missouri, US | |
2491951 | 2491951 | 2022-06-29 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-06-30 04:21:01 | Mercer, Missouri, US | |
2241333 | 2241333 | 2022-06-28 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-06-29 04:20:59 | Mercer, Missouri, US | |
2149575 | 2149575 | 2022-06-27 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-06-28 04:20:58 | Mercer, Missouri, US | |
477376 | 477376 | 2022-06-26 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-06-27 04:21:00 | Mercer, Missouri, US | |
940751 | 940751 | 2022-06-25 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-06-26 04:21:02 | Mercer, Missouri, US | |
3348571 | 3348571 | 2022-06-24 | US | Missouri | Mercer | 29129 | 737 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-06-25 04:20:57 | Mercer, Missouri, US | |
1766473 | 1766473 | 2022-06-20 | US | Texas | Kimble | 48267 | 737 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-21 04:20:56 | Kimble, Texas, US | |
3272659 | 3272659 | 2022-06-19 | US | Texas | Kimble | 48267 | 737 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-20 04:21:01 | Kimble, Texas, US | |
3400571 | 3400571 | 2022-06-18 | US | Texas | Kimble | 48267 | 737 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-19 04:20:51 | Kimble, Texas, US | |
2314448 | 2314448 | 2022-06-17 | US | Texas | Kimble | 48267 | 737 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-18 04:21:10 | Kimble, Texas, US | |
561952 | 561952 | 2022-06-16 | US | Texas | Kimble | 48267 | 737 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-17 04:20:56 | Kimble, Texas, US | |
3985754 | 3985754 | 2022-06-15 | US | Texas | Kimble | 48267 | 737 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-06-16 04:20:55 | Kimble, Texas, US | |
949250 | 949250 | 2022-06-14 | US | North Dakota | Emmons | 38029 | 737 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-06-15 04:20:54 | Emmons, North Dakota, US | |
3159767 | 3159767 | 2022-06-09 | US | Nebraska | Valley | 31175 | 737 | 6 | 0 | 41.56730777 | -98.98197724 | 2022-06-10 04:20:55 | Valley, Nebraska, US | |
1423234 | 1423234 | 2022-06-08 | US | Nebraska | Valley | 31175 | 737 | 6 | 0 | 41.56730777 | -98.98197724 | 2022-06-09 04:20:54 | Valley, Nebraska, US | |
3728348 | 3728348 | 2022-06-07 | US | Nebraska | Valley | 31175 | 737 | 6 | 0 | 41.56730777 | -98.98197724 | 2022-06-08 04:20:55 | Valley, Nebraska, US | |
3889750 | 3889750 | 2022-06-06 | US | Nebraska | Valley | 31175 | 737 | 6 | 0 | 41.56730777 | -98.98197724 | 2022-06-07 04:21:08 | Valley, Nebraska, US | |
2600009 | 2600009 | 2022-05-05 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-05-06 04:21:00 | Schuyler, Missouri, US | |
3267458 | 3267458 | 2022-05-04 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-05-05 04:20:55 | Schuyler, Missouri, US | |
1574097 | 1574097 | 2022-05-03 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-05-04 04:20:59 | Schuyler, Missouri, US | |
465357 | 465357 | 2022-05-02 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-05-03 04:21:00 | Schuyler, Missouri, US | |
3917996 | 3917996 | 2022-05-01 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-05-02 04:21:10 | Schuyler, Missouri, US | |
2842800 | 2842800 | 2022-04-30 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-05-01 04:20:57 | Schuyler, Missouri, US | |
1159113 | 1159113 | 2022-04-29 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-30 04:21:05 | Schuyler, Missouri, US | |
1698295 | 1698295 | 2022-04-28 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-29 04:20:59 | Schuyler, Missouri, US | |
3853778 | 3853778 | 2022-04-27 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-28 04:20:47 | Schuyler, Missouri, US | |
1328208 | 1328208 | 2022-04-26 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-27 04:20:52 | Schuyler, Missouri, US | |
3724162 | 3724162 | 2022-04-25 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-26 04:20:51 | Schuyler, Missouri, US | |
2030730 | 2030730 | 2022-04-24 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-25 04:20:56 | Schuyler, Missouri, US | |
748305 | 748305 | 2022-04-23 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-24 04:20:56 | Schuyler, Missouri, US | |
3438790 | 3438790 | 2022-04-22 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-23 04:20:50 | Schuyler, Missouri, US | |
2894375 | 2894375 | 2022-04-21 | US | Missouri | Schuyler | 29197 | 737 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-22 04:20:45 | Schuyler, Missouri, US | |
3870692 | 3870692 | 2022-04-05 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-04-06 04:20:49 | Kinney, Texas, US | |
2752034 | 2752034 | 2022-04-04 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-04-05 04:20:48 | Kinney, Texas, US | |
3733380 | 3733380 | 2022-04-03 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-04-04 04:20:51 | Kinney, Texas, US | |
502815 | 502815 | 2022-04-02 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-04-03 04:20:48 | Kinney, Texas, US | |
3353800 | 3353800 | 2022-04-01 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-04-02 04:20:47 | Kinney, Texas, US | |
1543105 | 1543105 | 2022-03-31 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-04-01 04:20:28 | Kinney, Texas, US | |
2481118 | 2481118 | 2022-03-30 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-03-31 04:20:56 | Kinney, Texas, US | |
161159 | 161159 | 2022-03-29 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-03-30 04:20:45 | Kinney, Texas, US | |
1439730 | 1439730 | 2022-03-28 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-03-29 04:20:46 | Kinney, Texas, US | |
879411 | 879411 | 2022-03-27 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-03-28 04:20:33 | Kinney, Texas, US | |
2166694 | 2166694 | 2022-03-26 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-03-27 04:20:47 | Kinney, Texas, US | |
1723630 | 1723630 | 2022-03-25 | US | Texas | Kinney | 48271 | 737 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-03-26 04:20:23 | Kinney, Texas, US | |
3914224 | 3914224 | 2022-02-20 | US | New Mexico | Mora | 35033 | 737 | 16 | 0 | 36.01095101 | -104.9497716 | 2022-02-21 04:21:05 | Mora, New Mexico, US | |
3877782 | 3877782 | 2022-02-19 | US | New Mexico | Mora | 35033 | 737 | 16 | 0 | 36.01095101 | -104.9497716 | 2022-02-20 04:21:00 | Mora, New Mexico, US | |
3858038 | 3858038 | 2022-02-18 | US | New Mexico | Mora | 35033 | 737 | 16 | 0 | 36.01095101 | -104.9497716 | 2022-02-19 04:21:11 | Mora, New Mexico, US | |
3822173 | 3822173 | 2022-02-16 | US | Minnesota | Lake of the Woods | 27077 | 737 | 5 | 0 | 48.77217001 | -94.90274472 | 2022-02-17 04:20:56 | Lake of the Woods, Minnesota, US | |
980108 | 980108 | 2022-02-01 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-02-02 04:21:09 | Adams, Iowa, US | |
2658950 | 2658950 | 2022-01-31 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-02-01 04:21:11 | Adams, Iowa, US | |
3303375 | 3303375 | 2022-01-30 | US | Texas | Mason | 48319 | 737 | 9 | 0 | 30.71780434 | -99.22629416 | 2022-01-31 04:21:09 | Mason, Texas, US | |
3301367 | 3301367 | 2022-01-30 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-01-31 04:21:09 | Adams, Iowa, US | |
3063158 | 3063158 | 2022-01-29 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-01-30 04:21:26 | Adams, Iowa, US | |
3811092 | 3811092 | 2022-01-28 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-01-29 04:21:10 | Adams, Iowa, US | |
1780546 | 1780546 | 2022-01-27 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-01-28 04:21:09 | Adams, Iowa, US | |
1319374 | 1319374 | 2022-01-26 | US | Iowa | Adams | 19003 | 737 | 12 | 0 | 41.02903567 | -94.69932645 | 2022-01-27 04:21:19 | Adams, Iowa, US | |
1142254 | 1142254 | 2022-01-23 | US | Kansas | Rush | 20165 | 737 | 17 | 0 | 38.52275276 | -99.30863983 | 2022-01-24 04:21:12 | Rush, Kansas, US | |
2834172 | 2834172 | 2022-01-22 | US | Kansas | Rush | 20165 | 737 | 17 | 0 | 38.52275276 | -99.30863983 | 2022-01-23 04:21:13 | Rush, Kansas, US | |
3426290 | 3426290 | 2022-01-21 | US | Kansas | Rush | 20165 | 737 | 17 | 0 | 38.52275276 | -99.30863983 | 2022-01-22 04:21:13 | Rush, Kansas, US | |
102377 | 102377 | 2022-01-14 | US | Texas | Coke | 48081 | 737 | 18 | 0 | 31.88911733 | -100.5297533 | 2022-01-15 04:21:07 | Coke, Texas, US | |
1218631 | 1218631 | 2022-01-08 | US | Texas | Crockett | 48105 | 737 | 17 | 0 | 30.72367027 | -101.4134238 | 2022-01-09 04:21:46 | Crockett, Texas, US | |
2612916 | 2612916 | 2022-01-06 | US | South Dakota | Edmunds | 46045 | 737 | 14 | 0 | 45.41846445 | -99.21545423 | 2022-01-07 04:22:09 | Edmunds, South Dakota, US | |
1702108 | 1702108 | 2022-01-03 | US | Minnesota | Red Lake | 27125 | 737 | 11 | 0 | 47.87197525 | -96.09561104 | 2022-01-04 04:22:17 | Red Lake, Minnesota, US | |
1671820 | 1671820 | 2021-12-29 | US | Virginia | King and Queen | 51097 | 737 | 9 | 0 | 37.71044922 | -76.88689628 | 2021-12-30 04:21:25 | King and Queen, Virginia, US | |
1435122 | 1435122 | 2021-12-28 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-29 03:21:43 | Grant, Oklahoma, US | |
733083 | 733083 | 2021-12-27 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-28 04:21:47 | Grant, Oklahoma, US | |
2114255 | 2114255 | 2021-12-26 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-27 04:21:58 | Grant, Oklahoma, US | |
2113376 | 2113376 | 2021-12-26 | US | Michigan | Ontonagon | 26131 | 737 | 26 | 0 | 46.665226200000006 | -89.31390481 | 2021-12-27 04:21:58 | Ontonagon, Michigan, US | |
3607627 | 3607627 | 2021-12-25 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-26 04:21:50 | Grant, Oklahoma, US | |
3606748 | 3606748 | 2021-12-25 | US | Michigan | Ontonagon | 26131 | 737 | 26 | 0 | 46.665226200000006 | -89.31390481 | 2021-12-26 04:21:50 | Ontonagon, Michigan, US | |
2965945 | 2965945 | 2021-12-24 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-25 04:21:37 | Grant, Oklahoma, US | |
2965066 | 2965066 | 2021-12-24 | US | Michigan | Ontonagon | 26131 | 737 | 26 | 0 | 46.665226200000006 | -89.31390481 | 2021-12-25 04:21:37 | Ontonagon, Michigan, US | |
3818977 | 3818977 | 2021-12-23 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-24 04:21:34 | Grant, Oklahoma, US | |
3818098 | 3818098 | 2021-12-23 | US | Michigan | Ontonagon | 26131 | 737 | 26 | 0 | 46.665226200000006 | -89.31390481 | 2021-12-24 04:21:34 | Ontonagon, Michigan, US | |
800985 | 800985 | 2021-12-22 | US | Oklahoma | Grant | 40053 | 737 | 8 | 0 | 36.796296999999996 | -97.78638765 | 2021-12-23 04:21:21 | Grant, Oklahoma, US | |
800106 | 800106 | 2021-12-22 | US | Michigan | Ontonagon | 26131 | 737 | 26 | 0 | 46.665226200000006 | -89.31390481 | 2021-12-23 04:21:21 | Ontonagon, Michigan, US | |
1033482 | 1033482 | 2021-12-06 | US | Texas | Hall | 48191 | 737 | 15 | 0 | 34.5307555 | -100.68138520000001 | 2021-12-07 04:22:34 | Hall, Texas, US | |
3402792 | 3402792 | 2021-11-30 | US | Kansas | Stafford | 20185 | 737 | 19 | 0 | 38.03100851 | -98.71762001 | 2021-12-01 04:22:29 | Stafford, Kansas, US | |
151335 | 151335 | 2021-11-29 | US | Kansas | Stafford | 20185 | 737 | 19 | 0 | 38.03100851 | -98.71762001 | 2021-11-30 04:22:53 | Stafford, Kansas, US | |
3073356 | 3073356 | 2021-11-23 | US | Virginia | Cumberland | 51049 | 737 | 19 | 0 | 37.51328851 | -78.24398086 | 2021-11-24 04:22:14 | Cumberland, Virginia, US | |
3751767 | 3751767 | 2021-11-22 | US | Oregon | Wallowa | 41063 | 737 | 13 | 0 | 45.57894064 | -117.18353799999998 | 2021-11-23 04:22:39 | Wallowa, Oregon, US | |
1016459 | 1016459 | 2021-11-21 | US | Nebraska | Thayer | 31169 | 737 | 4 | 0 | 40.17626377 | -97.59504381 | 2021-11-22 04:22:20 | Thayer, Nebraska, US | |
724623 | 724623 | 2021-11-20 | US | Nebraska | Thayer | 31169 | 737 | 4 | 0 | 40.17626377 | -97.59504381 | 2021-11-21 04:22:13 | Thayer, Nebraska, US | |
164153 | 164153 | 2021-11-19 | US | Nebraska | Thayer | 31169 | 737 | 4 | 0 | 40.17626377 | -97.59504381 | 2021-11-20 04:22:17 | Thayer, Nebraska, US | |
449444 | 449444 | 2021-11-17 | US | Nebraska | Furnas | 31065 | 737 | 5 | 0 | 40.17642064 | -99.91247454 | 2021-11-18 04:21:33 | Furnas, Nebraska, US | |
1322892 | 1322892 | 2021-11-14 | US | Colorado | Washington | 8121 | 737 | 25 | 0 | 39.97015535 | -103.202587 | 2021-11-15 04:21:36 | Washington, Colorado, US | |
701530 | 701530 | 2021-11-04 | US | Texas | Hudspeth | 48229 | 737 | 14 | 0 | 31.45628381 | -105.388178 | 2021-11-05 04:21:54 | Hudspeth, Texas, 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]);