ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 20123 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
7487 | 7487 | 2020-03-22 | Mitchell | Kansas | 20123 | 1 | 0 |
26842 | 26842 | 2020-04-02 | Mitchell | Kansas | 20123 | 2 | 0 |
29157 | 29157 | 2020-04-03 | Mitchell | Kansas | 20123 | 2 | 0 |
31531 | 31531 | 2020-04-04 | Mitchell | Kansas | 20123 | 2 | 0 |
33945 | 33945 | 2020-04-05 | Mitchell | Kansas | 20123 | 2 | 0 |
36402 | 36402 | 2020-04-06 | Mitchell | Kansas | 20123 | 2 | 0 |
38904 | 38904 | 2020-04-07 | Mitchell | Kansas | 20123 | 2 | 0 |
41451 | 41451 | 2020-04-08 | Mitchell | Kansas | 20123 | 2 | 0 |
44027 | 44027 | 2020-04-09 | Mitchell | Kansas | 20123 | 2 | 0 |
46634 | 46634 | 2020-04-10 | Mitchell | Kansas | 20123 | 2 | 0 |
49270 | 49270 | 2020-04-11 | Mitchell | Kansas | 20123 | 2 | 0 |
51935 | 51935 | 2020-04-12 | Mitchell | Kansas | 20123 | 2 | 0 |
54617 | 54617 | 2020-04-13 | Mitchell | Kansas | 20123 | 2 | 0 |
57311 | 57311 | 2020-04-14 | Mitchell | Kansas | 20123 | 2 | 0 |
60019 | 60019 | 2020-04-15 | Mitchell | Kansas | 20123 | 2 | 0 |
62740 | 62740 | 2020-04-16 | Mitchell | Kansas | 20123 | 2 | 0 |
65476 | 65476 | 2020-04-17 | Mitchell | Kansas | 20123 | 2 | 0 |
68225 | 68225 | 2020-04-18 | Mitchell | Kansas | 20123 | 2 | 0 |
70986 | 70986 | 2020-04-19 | Mitchell | Kansas | 20123 | 2 | 0 |
73758 | 73758 | 2020-04-20 | Mitchell | Kansas | 20123 | 2 | 0 |
76538 | 76538 | 2020-04-21 | Mitchell | Kansas | 20123 | 2 | 0 |
79323 | 79323 | 2020-04-22 | Mitchell | Kansas | 20123 | 2 | 0 |
82118 | 82118 | 2020-04-23 | Mitchell | Kansas | 20123 | 2 | 0 |
84921 | 84921 | 2020-04-24 | Mitchell | Kansas | 20123 | 2 | 0 |
87730 | 87730 | 2020-04-25 | Mitchell | Kansas | 20123 | 2 | 0 |
90546 | 90546 | 2020-04-26 | Mitchell | Kansas | 20123 | 2 | 0 |
93367 | 93367 | 2020-04-27 | Mitchell | Kansas | 20123 | 2 | 0 |
96199 | 96199 | 2020-04-28 | Mitchell | Kansas | 20123 | 2 | 0 |
8649 | 8649 | 2020-03-23 | Mitchell | Kansas | 20123 | 3 | 0 |
9930 | 9930 | 2020-03-24 | Mitchell | Kansas | 20123 | 3 | 0 |
11328 | 11328 | 2020-03-25 | Mitchell | Kansas | 20123 | 3 | 0 |
12896 | 12896 | 2020-03-26 | Mitchell | Kansas | 20123 | 3 | 0 |
14597 | 14597 | 2020-03-27 | Mitchell | Kansas | 20123 | 3 | 0 |
16405 | 16405 | 2020-03-28 | Mitchell | Kansas | 20123 | 3 | 0 |
18311 | 18311 | 2020-03-29 | Mitchell | Kansas | 20123 | 3 | 0 |
20324 | 20324 | 2020-03-30 | Mitchell | Kansas | 20123 | 3 | 0 |
22423 | 22423 | 2020-03-31 | Mitchell | Kansas | 20123 | 3 | 0 |
24598 | 24598 | 2020-04-01 | Mitchell | Kansas | 20123 | 3 | 0 |
99045 | 99045 | 2020-04-29 | Mitchell | Kansas | 20123 | 3 | 0 |
101897 | 101897 | 2020-04-30 | Mitchell | Kansas | 20123 | 3 | 0 |
104757 | 104757 | 2020-05-01 | Mitchell | Kansas | 20123 | 3 | 0 |
107622 | 107622 | 2020-05-02 | Mitchell | Kansas | 20123 | 3 | 0 |
110493 | 110493 | 2020-05-03 | Mitchell | Kansas | 20123 | 3 | 0 |
113370 | 113370 | 2020-05-04 | Mitchell | Kansas | 20123 | 3 | 0 |
116252 | 116252 | 2020-05-05 | Mitchell | Kansas | 20123 | 3 | 0 |
119213 | 119213 | 2020-05-06 | Mitchell | Kansas | 20123 | 3 | 0 |
122183 | 122183 | 2020-05-07 | Mitchell | Kansas | 20123 | 3 | 0 |
125165 | 125165 | 2020-05-08 | Mitchell | Kansas | 20123 | 3 | 0 |
128153 | 128153 | 2020-05-09 | Mitchell | Kansas | 20123 | 3 | 0 |
131143 | 131143 | 2020-05-10 | Mitchell | Kansas | 20123 | 3 | 0 |
134134 | 134134 | 2020-05-11 | Mitchell | Kansas | 20123 | 3 | 0 |
137124 | 137124 | 2020-05-12 | Mitchell | Kansas | 20123 | 3 | 0 |
140117 | 140117 | 2020-05-13 | Mitchell | Kansas | 20123 | 3 | 0 |
143113 | 143113 | 2020-05-14 | Mitchell | Kansas | 20123 | 3 | 0 |
146113 | 146113 | 2020-05-15 | Mitchell | Kansas | 20123 | 3 | 0 |
149117 | 149117 | 2020-05-16 | Mitchell | Kansas | 20123 | 3 | 0 |
152128 | 152128 | 2020-05-17 | Mitchell | Kansas | 20123 | 3 | 0 |
155140 | 155140 | 2020-05-18 | Mitchell | Kansas | 20123 | 3 | 0 |
158157 | 158157 | 2020-05-19 | Mitchell | Kansas | 20123 | 3 | 0 |
161182 | 161182 | 2020-05-20 | Mitchell | Kansas | 20123 | 3 | 0 |
164211 | 164211 | 2020-05-21 | Mitchell | Kansas | 20123 | 3 | 0 |
167246 | 167246 | 2020-05-22 | Mitchell | Kansas | 20123 | 3 | 0 |
170284 | 170284 | 2020-05-23 | Mitchell | Kansas | 20123 | 3 | 0 |
173325 | 173325 | 2020-05-24 | Mitchell | Kansas | 20123 | 3 | 0 |
176369 | 176369 | 2020-05-25 | Mitchell | Kansas | 20123 | 3 | 0 |
179413 | 179413 | 2020-05-26 | Mitchell | Kansas | 20123 | 3 | 0 |
182458 | 182458 | 2020-05-27 | Mitchell | Kansas | 20123 | 3 | 0 |
185512 | 185512 | 2020-05-28 | Mitchell | Kansas | 20123 | 3 | 0 |
188570 | 188570 | 2020-05-29 | Mitchell | Kansas | 20123 | 4 | 0 |
191634 | 191634 | 2020-05-30 | Mitchell | Kansas | 20123 | 4 | 0 |
194702 | 194702 | 2020-05-31 | Mitchell | Kansas | 20123 | 4 | 0 |
197772 | 197772 | 2020-06-01 | Mitchell | Kansas | 20123 | 4 | 0 |
200844 | 200844 | 2020-06-02 | Mitchell | Kansas | 20123 | 4 | 0 |
203920 | 203920 | 2020-06-03 | Mitchell | Kansas | 20123 | 4 | 0 |
207001 | 207001 | 2020-06-04 | Mitchell | Kansas | 20123 | 4 | 0 |
210082 | 210082 | 2020-06-05 | Mitchell | Kansas | 20123 | 4 | 0 |
213167 | 213167 | 2020-06-06 | Mitchell | Kansas | 20123 | 4 | 0 |
216254 | 216254 | 2020-06-07 | Mitchell | Kansas | 20123 | 4 | 0 |
219346 | 219346 | 2020-06-08 | Mitchell | Kansas | 20123 | 4 | 0 |
222441 | 222441 | 2020-06-09 | Mitchell | Kansas | 20123 | 4 | 0 |
225536 | 225536 | 2020-06-10 | Mitchell | Kansas | 20123 | 4 | 0 |
228638 | 228638 | 2020-06-11 | Mitchell | Kansas | 20123 | 4 | 0 |
231741 | 231741 | 2020-06-12 | Mitchell | Kansas | 20123 | 4 | 0 |
234847 | 234847 | 2020-06-13 | Mitchell | Kansas | 20123 | 4 | 0 |
237954 | 237954 | 2020-06-14 | Mitchell | Kansas | 20123 | 4 | 0 |
241063 | 241063 | 2020-06-15 | Mitchell | Kansas | 20123 | 4 | 0 |
244174 | 244174 | 2020-06-16 | Mitchell | Kansas | 20123 | 4 | 0 |
247287 | 247287 | 2020-06-17 | Mitchell | Kansas | 20123 | 4 | 0 |
250399 | 250399 | 2020-06-18 | Mitchell | Kansas | 20123 | 4 | 0 |
253514 | 253514 | 2020-06-19 | Mitchell | Kansas | 20123 | 4 | 0 |
256634 | 256634 | 2020-06-20 | Mitchell | Kansas | 20123 | 4 | 0 |
259760 | 259760 | 2020-06-21 | Mitchell | Kansas | 20123 | 4 | 0 |
262887 | 262887 | 2020-06-22 | Mitchell | Kansas | 20123 | 4 | 0 |
266015 | 266015 | 2020-06-23 | Mitchell | Kansas | 20123 | 4 | 0 |
269147 | 269147 | 2020-06-24 | Mitchell | Kansas | 20123 | 4 | 0 |
272284 | 272284 | 2020-06-25 | Mitchell | Kansas | 20123 | 4 | 0 |
275427 | 275427 | 2020-06-26 | Mitchell | Kansas | 20123 | 4 | 0 |
278575 | 278575 | 2020-06-27 | Mitchell | Kansas | 20123 | 4 | 0 |
281723 | 281723 | 2020-06-28 | Mitchell | Kansas | 20123 | 4 | 0 |
284868 | 284868 | 2020-06-29 | Mitchell | Kansas | 20123 | 4 | 0 |
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);