ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 20103 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3979 | 3979 | 2020-03-18 | Leavenworth | Kansas | 20103 | 2 | 0 |
4661 | 4661 | 2020-03-19 | Leavenworth | Kansas | 20103 | 2 | 0 |
5472 | 5472 | 2020-03-20 | Leavenworth | Kansas | 20103 | 4 | 0 |
6417 | 6417 | 2020-03-21 | Leavenworth | Kansas | 20103 | 4 | 0 |
7485 | 7485 | 2020-03-22 | Leavenworth | Kansas | 20103 | 4 | 0 |
8646 | 8646 | 2020-03-23 | Leavenworth | Kansas | 20103 | 5 | 0 |
9927 | 9927 | 2020-03-24 | Leavenworth | Kansas | 20103 | 7 | 0 |
11325 | 11325 | 2020-03-25 | Leavenworth | Kansas | 20103 | 11 | 0 |
12893 | 12893 | 2020-03-26 | Leavenworth | Kansas | 20103 | 12 | 0 |
14593 | 14593 | 2020-03-27 | Leavenworth | Kansas | 20103 | 12 | 0 |
16400 | 16400 | 2020-03-28 | Leavenworth | Kansas | 20103 | 15 | 0 |
18306 | 18306 | 2020-03-29 | Leavenworth | Kansas | 20103 | 17 | 0 |
20319 | 20319 | 2020-03-30 | Leavenworth | Kansas | 20103 | 20 | 0 |
22418 | 22418 | 2020-03-31 | Leavenworth | Kansas | 20103 | 24 | 0 |
24593 | 24593 | 2020-04-01 | Leavenworth | Kansas | 20103 | 25 | 0 |
26837 | 26837 | 2020-04-02 | Leavenworth | Kansas | 20103 | 27 | 0 |
29151 | 29151 | 2020-04-03 | Leavenworth | Kansas | 20103 | 31 | 1 |
31525 | 31525 | 2020-04-04 | Leavenworth | Kansas | 20103 | 33 | 1 |
33939 | 33939 | 2020-04-05 | Leavenworth | Kansas | 20103 | 38 | 1 |
36396 | 36396 | 2020-04-06 | Leavenworth | Kansas | 20103 | 40 | 1 |
38898 | 38898 | 2020-04-07 | Leavenworth | Kansas | 20103 | 43 | 1 |
41445 | 41445 | 2020-04-08 | Leavenworth | Kansas | 20103 | 59 | 1 |
44021 | 44021 | 2020-04-09 | Leavenworth | Kansas | 20103 | 61 | 1 |
46628 | 46628 | 2020-04-10 | Leavenworth | Kansas | 20103 | 66 | 1 |
49264 | 49264 | 2020-04-11 | Leavenworth | Kansas | 20103 | 75 | 1 |
51929 | 51929 | 2020-04-12 | Leavenworth | Kansas | 20103 | 80 | 1 |
54611 | 54611 | 2020-04-13 | Leavenworth | Kansas | 20103 | 87 | 1 |
57305 | 57305 | 2020-04-14 | Leavenworth | Kansas | 20103 | 90 | 1 |
60013 | 60013 | 2020-04-15 | Leavenworth | Kansas | 20103 | 93 | 1 |
62734 | 62734 | 2020-04-16 | Leavenworth | Kansas | 20103 | 114 | 1 |
65470 | 65470 | 2020-04-17 | Leavenworth | Kansas | 20103 | 117 | 2 |
68219 | 68219 | 2020-04-18 | Leavenworth | Kansas | 20103 | 123 | 2 |
70980 | 70980 | 2020-04-19 | Leavenworth | Kansas | 20103 | 128 | 2 |
73752 | 73752 | 2020-04-20 | Leavenworth | Kansas | 20103 | 135 | 2 |
76532 | 76532 | 2020-04-21 | Leavenworth | Kansas | 20103 | 136 | 3 |
79317 | 79317 | 2020-04-22 | Leavenworth | Kansas | 20103 | 150 | 3 |
82112 | 82112 | 2020-04-23 | Leavenworth | Kansas | 20103 | 154 | 3 |
84914 | 84914 | 2020-04-24 | Leavenworth | Kansas | 20103 | 154 | 3 |
87723 | 87723 | 2020-04-25 | Leavenworth | Kansas | 20103 | 169 | 3 |
90539 | 90539 | 2020-04-26 | Leavenworth | Kansas | 20103 | 172 | 3 |
93360 | 93360 | 2020-04-27 | Leavenworth | Kansas | 20103 | 184 | 4 |
96192 | 96192 | 2020-04-28 | Leavenworth | Kansas | 20103 | 187 | 4 |
99038 | 99038 | 2020-04-29 | Leavenworth | Kansas | 20103 | 196 | 4 |
101890 | 101890 | 2020-04-30 | Leavenworth | Kansas | 20103 | 356 | 4 |
104750 | 104750 | 2020-05-01 | Leavenworth | Kansas | 20103 | 372 | 5 |
107615 | 107615 | 2020-05-02 | Leavenworth | Kansas | 20103 | 386 | 5 |
110486 | 110486 | 2020-05-03 | Leavenworth | Kansas | 20103 | 498 | 5 |
113363 | 113363 | 2020-05-04 | Leavenworth | Kansas | 20103 | 529 | 5 |
116245 | 116245 | 2020-05-05 | Leavenworth | Kansas | 20103 | 602 | 6 |
119206 | 119206 | 2020-05-06 | Leavenworth | Kansas | 20103 | 783 | 6 |
122176 | 122176 | 2020-05-07 | Leavenworth | Kansas | 20103 | 887 | 6 |
125158 | 125158 | 2020-05-08 | Leavenworth | Kansas | 20103 | 907 | 6 |
128146 | 128146 | 2020-05-09 | Leavenworth | Kansas | 20103 | 910 | 6 |
131136 | 131136 | 2020-05-10 | Leavenworth | Kansas | 20103 | 920 | 6 |
134127 | 134127 | 2020-05-11 | Leavenworth | Kansas | 20103 | 939 | 6 |
137117 | 137117 | 2020-05-12 | Leavenworth | Kansas | 20103 | 939 | 6 |
140110 | 140110 | 2020-05-13 | Leavenworth | Kansas | 20103 | 952 | 6 |
143106 | 143106 | 2020-05-14 | Leavenworth | Kansas | 20103 | 952 | 6 |
146106 | 146106 | 2020-05-15 | Leavenworth | Kansas | 20103 | 957 | 6 |
149110 | 149110 | 2020-05-16 | Leavenworth | Kansas | 20103 | 958 | 6 |
152121 | 152121 | 2020-05-17 | Leavenworth | Kansas | 20103 | 958 | 6 |
155133 | 155133 | 2020-05-18 | Leavenworth | Kansas | 20103 | 1051 | 6 |
158150 | 158150 | 2020-05-19 | Leavenworth | Kansas | 20103 | 1053 | 7 |
161175 | 161175 | 2020-05-20 | Leavenworth | Kansas | 20103 | 1058 | 7 |
164204 | 164204 | 2020-05-21 | Leavenworth | Kansas | 20103 | 1062 | 7 |
176362 | 176362 | 2020-05-25 | Leavenworth | Kansas | 20103 | 1067 | 7 |
167239 | 167239 | 2020-05-22 | Leavenworth | Kansas | 20103 | 1069 | 7 |
170277 | 170277 | 2020-05-23 | Leavenworth | Kansas | 20103 | 1069 | 7 |
173318 | 173318 | 2020-05-24 | Leavenworth | Kansas | 20103 | 1069 | 7 |
179406 | 179406 | 2020-05-26 | Leavenworth | Kansas | 20103 | 1070 | 7 |
182451 | 182451 | 2020-05-27 | Leavenworth | Kansas | 20103 | 1074 | 7 |
185505 | 185505 | 2020-05-28 | Leavenworth | Kansas | 20103 | 1074 | 7 |
188563 | 188563 | 2020-05-29 | Leavenworth | Kansas | 20103 | 1082 | 7 |
191627 | 191627 | 2020-05-30 | Leavenworth | Kansas | 20103 | 1082 | 7 |
194695 | 194695 | 2020-05-31 | Leavenworth | Kansas | 20103 | 1082 | 7 |
197765 | 197765 | 2020-06-01 | Leavenworth | Kansas | 20103 | 1093 | 7 |
200837 | 200837 | 2020-06-02 | Leavenworth | Kansas | 20103 | 1095 | 7 |
203913 | 203913 | 2020-06-03 | Leavenworth | Kansas | 20103 | 1098 | 7 |
206994 | 206994 | 2020-06-04 | Leavenworth | Kansas | 20103 | 1099 | 7 |
210075 | 210075 | 2020-06-05 | Leavenworth | Kansas | 20103 | 1100 | 7 |
213160 | 213160 | 2020-06-06 | Leavenworth | Kansas | 20103 | 1100 | 7 |
216247 | 216247 | 2020-06-07 | Leavenworth | Kansas | 20103 | 1100 | 7 |
219339 | 219339 | 2020-06-08 | Leavenworth | Kansas | 20103 | 1103 | 7 |
222434 | 222434 | 2020-06-09 | Leavenworth | Kansas | 20103 | 1103 | 7 |
225529 | 225529 | 2020-06-10 | Leavenworth | Kansas | 20103 | 1103 | 7 |
228631 | 228631 | 2020-06-11 | Leavenworth | Kansas | 20103 | 1105 | 7 |
231734 | 231734 | 2020-06-12 | Leavenworth | Kansas | 20103 | 1106 | 7 |
234840 | 234840 | 2020-06-13 | Leavenworth | Kansas | 20103 | 1106 | 7 |
237947 | 237947 | 2020-06-14 | Leavenworth | Kansas | 20103 | 1106 | 7 |
241056 | 241056 | 2020-06-15 | Leavenworth | Kansas | 20103 | 1109 | 7 |
244167 | 244167 | 2020-06-16 | Leavenworth | Kansas | 20103 | 1111 | 7 |
247280 | 247280 | 2020-06-17 | Leavenworth | Kansas | 20103 | 1118 | 7 |
250392 | 250392 | 2020-06-18 | Leavenworth | Kansas | 20103 | 1120 | 7 |
253507 | 253507 | 2020-06-19 | Leavenworth | Kansas | 20103 | 1122 | 7 |
256627 | 256627 | 2020-06-20 | Leavenworth | Kansas | 20103 | 1122 | 7 |
259753 | 259753 | 2020-06-21 | Leavenworth | Kansas | 20103 | 1122 | 7 |
262880 | 262880 | 2020-06-22 | Leavenworth | Kansas | 20103 | 1132 | 7 |
266008 | 266008 | 2020-06-23 | Leavenworth | Kansas | 20103 | 1132 | 7 |
269138 | 269138 | 2020-06-24 | Leavenworth | Kansas | 20103 | 1137 | 7 |
272275 | 272275 | 2020-06-25 | Leavenworth | Kansas | 20103 | 1137 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);