johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where active = 111, country_or_region = "US" and province_or_state = "Kansas" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1820105 | 1820105 | 2020-12-08 | US | Kansas | Osborne | 20141 | 111 | 0 | 0 | 111 | 39.3503437 | -98.76753828 | 2020-12-09 05:28:01 | Osborne, Kansas, US |
2348741 | 2348741 | 2020-12-07 | US | Kansas | Osborne | 20141 | 111 | 0 | 0 | 111 | 39.3503437 | -98.76753828 | 2020-12-08 05:27:42 | Osborne, Kansas, US |
76384 | 76384 | 2020-12-03 | US | Kansas | Kiowa | 20097 | 111 | 0 | 0 | 111 | 37.55848695 | -99.2856537 | 2020-12-04 05:27:27 | Kiowa, Kansas, US |
739596 | 739596 | 2020-12-02 | US | Kansas | Kiowa | 20097 | 111 | 0 | 0 | 111 | 37.55848695 | -99.2856537 | 2020-12-03 05:28:22 | Kiowa, Kansas, US |
3339871 | 3339871 | 2020-11-17 | US | Kansas | Graham | 20065 | 113 | 2 | 0 | 111 | 39.34987223 | -99.88332493 | 2020-11-18 05:40:31 | Graham, Kansas, US |
3170916 | 3170916 | 2020-11-16 | US | Kansas | Graham | 20065 | 113 | 2 | 0 | 111 | 39.34987223 | -99.88332493 | 2020-11-17 05:25:54 | Graham, Kansas, US |
755547 | 755547 | 2020-10-28 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-29 04:24:49 | Allen, Kansas, US |
755560 | 755560 | 2020-10-28 | US | Kansas | Clay | 20027 | 114 | 3 | 0 | 111 | 39.34948772 | -97.16518128 | 2020-10-29 04:24:49 | Clay, Kansas, US |
1453831 | 1453831 | 2020-10-27 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-28 04:24:39 | Allen, Kansas, US |
3481555 | 3481555 | 2020-10-26 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-27 04:24:45 | Allen, Kansas, US |
9576 | 9576 | 2020-10-25 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-26 04:25:02 | Allen, Kansas, US |
9679 | 9679 | 2020-10-25 | US | Kansas | Wilson | 20205 | 113 | 2 | 0 | 111 | 37.55937174 | -95.74323255 | 2020-10-26 04:25:02 | Wilson, Kansas, US |
3652813 | 3652813 | 2020-10-24 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-25 04:24:36 | Allen, Kansas, US |
3652884 | 3652884 | 2020-10-24 | US | Kansas | Ottawa | 20143 | 111 | 0 | 0 | 111 | 39.13237408 | -97.65020313 | 2020-10-25 04:24:36 | Ottawa, Kansas, US |
3652916 | 3652916 | 2020-10-24 | US | Kansas | Wilson | 20205 | 113 | 2 | 0 | 111 | 37.55937174 | -95.74323255 | 2020-10-25 04:24:36 | Wilson, Kansas, US |
1055068 | 1055068 | 2020-10-23 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-24 04:24:46 | Allen, Kansas, US |
1055139 | 1055139 | 2020-10-23 | US | Kansas | Ottawa | 20143 | 111 | 0 | 0 | 111 | 39.13237408 | -97.65020313 | 2020-10-24 04:24:46 | Ottawa, Kansas, US |
1055171 | 1055171 | 2020-10-23 | US | Kansas | Wilson | 20205 | 113 | 2 | 0 | 111 | 37.55937174 | -95.74323255 | 2020-10-24 04:24:46 | Wilson, Kansas, US |
1178738 | 1178738 | 2020-10-22 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-23 04:24:46 | Allen, Kansas, US |
1178809 | 1178809 | 2020-10-22 | US | Kansas | Ottawa | 20143 | 111 | 0 | 0 | 111 | 39.13237408 | -97.65020313 | 2020-10-23 04:24:46 | Ottawa, Kansas, US |
2192843 | 2192843 | 2020-10-21 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-22 04:24:27 | Allen, Kansas, US |
2192914 | 2192914 | 2020-10-21 | US | Kansas | Ottawa | 20143 | 111 | 0 | 0 | 111 | 39.13237408 | -97.65020313 | 2020-10-22 04:24:27 | Ottawa, Kansas, US |
3991854 | 3991854 | 2020-10-20 | US | Kansas | Allen | 20001 | 112 | 1 | 0 | 111 | 37.88582951 | -95.30030847 | 2020-10-21 04:24:14 | Allen, Kansas, US |
3991925 | 3991925 | 2020-10-20 | US | Kansas | Ottawa | 20143 | 111 | 0 | 0 | 111 | 39.13237408 | -97.65020313 | 2020-10-21 04:24:14 | Ottawa, Kansas, US |
1027684 | 1027684 | 2020-10-17 | US | Kansas | Sheridan | 20179 | 111 | 0 | 0 | 111 | 39.35018161 | -100.4418259 | 2020-10-18 04:24:25 | Sheridan, Kansas, US |
2858179 | 2858179 | 2020-10-16 | US | Kansas | Sheridan | 20179 | 111 | 0 | 0 | 111 | 39.35018161 | -100.4418259 | 2020-10-17 04:24:12 | Sheridan, Kansas, US |
787698 | 787698 | 2020-10-15 | US | Kansas | Rice | 20159 | 112 | 1 | 0 | 111 | 38.34616184 | -98.19992118 | 2020-10-16 04:24:01 | Rice, Kansas, US |
787708 | 787708 | 2020-10-15 | US | Kansas | Sheridan | 20179 | 111 | 0 | 0 | 111 | 39.35018161 | -100.4418259 | 2020-10-16 04:24:01 | Sheridan, Kansas, US |
80377 | 80377 | 2020-10-14 | US | Kansas | Kingman | 20095 | 114 | 3 | 0 | 111 | 37.55909527 | -98.13638678 | 2020-10-15 04:24:28 | Kingman, Kansas, US |
3783146 | 3783146 | 2020-10-13 | US | Kansas | Anderson | 20003 | 111 | 0 | 0 | 111 | 38.21413251 | -95.29272815 | 2020-10-14 04:24:05 | Anderson, Kansas, US |
2515493 | 2515493 | 2020-10-03 | US | Kansas | Rooks | 20163 | 115 | 4 | 0 | 111 | 39.35022773 | -99.32484567 | 2020-10-04 04:23:44 | Rooks, Kansas, US |
3390711 | 3390711 | 2020-10-02 | US | Kansas | Rooks | 20163 | 115 | 4 | 0 | 111 | 39.35022773 | -99.32484567 | 2020-10-03 04:23:40 | Rooks, Kansas, US |
2380952 | 2380952 | 2020-10-01 | US | Kansas | Rooks | 20163 | 115 | 4 | 0 | 111 | 39.35022773 | -99.32484567 | 2020-10-02 04:23:51 | Rooks, Kansas, US |
1516704 | 1516704 | 2020-09-28 | US | Kansas | Osage | 20139 | 111 | 0 | 0 | 111 | 38.65235984 | -95.72707998 | 2020-09-29 04:23:42 | Osage, Kansas, US |
2583292 | 2583292 | 2020-09-27 | US | Kansas | Osage | 20139 | 111 | 0 | 0 | 111 | 38.65235984 | -95.72707998 | 2020-09-28 04:23:00 | Osage, Kansas, US |
2607273 | 2607273 | 2020-09-24 | US | Kansas | Brown | 20013 | 114 | 3 | 0 | 111 | 39.82652589 | -95.56421698 | 2020-09-25 04:23:00 | Brown, Kansas, US |
2456032 | 2456032 | 2020-09-19 | US | Kansas | Dickinson | 20041 | 112 | 1 | 0 | 111 | 38.86600962 | -97.15532383 | 2020-09-20 04:22:00 | Dickinson, Kansas, US |
2850101 | 2850101 | 2020-09-18 | US | Kansas | Dickinson | 20041 | 112 | 1 | 0 | 111 | 38.86600962 | -97.15532383 | 2020-09-19 04:22:00 | Dickinson, Kansas, US |
2061161 | 2061161 | 2020-09-01 | US | Kansas | Harper | 20077 | 112 | 1 | 0 | 111 | 37.19175361 | -98.07578384 | 2020-09-02 04:28:25 | Harper, Kansas, US |
195346 | 195346 | 2020-08-31 | US | Kansas | Harper | 20077 | 112 | 1 | 0 | 111 | 37.19175361 | -98.07578384 | 2020-09-01 04:28:31 | Harper, Kansas, US |
1613561 | 1613561 | 2020-08-14 | US | Kansas | Pottawatomie | 20149 | 111 | 0 | 0 | 111 | 39.37925655 | -96.34564657 | 2020-08-15 04:27:31 | Pottawatomie, Kansas, US |
2804615 | 2804615 | 2020-08-02 | US | Kansas | Barton | 20009 | 114 | 3 | 0 | 111 | 38.47889676 | -98.75636726 | 2020-08-03 04:34:35 | Barton, Kansas, US |
750183 | 750183 | 2020-08-01 | US | Kansas | Barton | 20009 | 114 | 3 | 0 | 111 | 38.47889676 | -98.75636726 | 2020-08-02 04:34:47 | Barton, Kansas, US |
2972426 | 2972426 | 2020-06-30 | US | Kansas | Jackson | 20085 | 112 | 1 | 0 | 111 | 39.41673394 | -95.79356799 | 2020-07-01 04:33:52 | Jackson, Kansas, 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]);