ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20063 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
14588 | 14588 | 2020-03-27 | Gove | Kansas | 20063 | 1 | 0 |
16395 | 16395 | 2020-03-28 | Gove | Kansas | 20063 | 1 | 0 |
18301 | 18301 | 2020-03-29 | Gove | Kansas | 20063 | 1 | 0 |
20314 | 20314 | 2020-03-30 | Gove | Kansas | 20063 | 1 | 0 |
22412 | 22412 | 2020-03-31 | Gove | Kansas | 20063 | 1 | 0 |
24587 | 24587 | 2020-04-01 | Gove | Kansas | 20063 | 1 | 0 |
26831 | 26831 | 2020-04-02 | Gove | Kansas | 20063 | 1 | 0 |
29145 | 29145 | 2020-04-03 | Gove | Kansas | 20063 | 1 | 0 |
31517 | 31517 | 2020-04-04 | Gove | Kansas | 20063 | 1 | 0 |
33931 | 33931 | 2020-04-05 | Gove | Kansas | 20063 | 1 | 0 |
36388 | 36388 | 2020-04-06 | Gove | Kansas | 20063 | 1 | 0 |
38890 | 38890 | 2020-04-07 | Gove | Kansas | 20063 | 1 | 0 |
41437 | 41437 | 2020-04-08 | Gove | Kansas | 20063 | 1 | 0 |
44013 | 44013 | 2020-04-09 | Gove | Kansas | 20063 | 1 | 0 |
46620 | 46620 | 2020-04-10 | Gove | Kansas | 20063 | 1 | 0 |
49255 | 49255 | 2020-04-11 | Gove | Kansas | 20063 | 1 | 0 |
51919 | 51919 | 2020-04-12 | Gove | Kansas | 20063 | 1 | 0 |
54601 | 54601 | 2020-04-13 | Gove | Kansas | 20063 | 1 | 0 |
57295 | 57295 | 2020-04-14 | Gove | Kansas | 20063 | 1 | 0 |
60003 | 60003 | 2020-04-15 | Gove | Kansas | 20063 | 1 | 0 |
62724 | 62724 | 2020-04-16 | Gove | Kansas | 20063 | 1 | 0 |
65460 | 65460 | 2020-04-17 | Gove | Kansas | 20063 | 1 | 0 |
68209 | 68209 | 2020-04-18 | Gove | Kansas | 20063 | 1 | 0 |
70970 | 70970 | 2020-04-19 | Gove | Kansas | 20063 | 1 | 0 |
73741 | 73741 | 2020-04-20 | Gove | Kansas | 20063 | 1 | 0 |
76521 | 76521 | 2020-04-21 | Gove | Kansas | 20063 | 1 | 0 |
79306 | 79306 | 2020-04-22 | Gove | Kansas | 20063 | 1 | 0 |
82099 | 82099 | 2020-04-23 | Gove | Kansas | 20063 | 1 | 0 |
84900 | 84900 | 2020-04-24 | Gove | Kansas | 20063 | 1 | 0 |
87709 | 87709 | 2020-04-25 | Gove | Kansas | 20063 | 1 | 0 |
90525 | 90525 | 2020-04-26 | Gove | Kansas | 20063 | 1 | 0 |
93346 | 93346 | 2020-04-27 | Gove | Kansas | 20063 | 1 | 0 |
96178 | 96178 | 2020-04-28 | Gove | Kansas | 20063 | 1 | 0 |
99024 | 99024 | 2020-04-29 | Gove | Kansas | 20063 | 1 | 0 |
101875 | 101875 | 2020-04-30 | Gove | Kansas | 20063 | 1 | 0 |
104735 | 104735 | 2020-05-01 | Gove | Kansas | 20063 | 1 | 0 |
107600 | 107600 | 2020-05-02 | Gove | Kansas | 20063 | 1 | 0 |
110471 | 110471 | 2020-05-03 | Gove | Kansas | 20063 | 1 | 0 |
113348 | 113348 | 2020-05-04 | Gove | Kansas | 20063 | 1 | 0 |
116230 | 116230 | 2020-05-05 | Gove | Kansas | 20063 | 1 | 0 |
119191 | 119191 | 2020-05-06 | Gove | Kansas | 20063 | 1 | 0 |
122161 | 122161 | 2020-05-07 | Gove | Kansas | 20063 | 1 | 0 |
125143 | 125143 | 2020-05-08 | Gove | Kansas | 20063 | 1 | 0 |
128131 | 128131 | 2020-05-09 | Gove | Kansas | 20063 | 1 | 0 |
131121 | 131121 | 2020-05-10 | Gove | Kansas | 20063 | 1 | 0 |
134112 | 134112 | 2020-05-11 | Gove | Kansas | 20063 | 1 | 0 |
137102 | 137102 | 2020-05-12 | Gove | Kansas | 20063 | 1 | 0 |
140095 | 140095 | 2020-05-13 | Gove | Kansas | 20063 | 1 | 0 |
143091 | 143091 | 2020-05-14 | Gove | Kansas | 20063 | 1 | 0 |
146091 | 146091 | 2020-05-15 | Gove | Kansas | 20063 | 1 | 0 |
149095 | 149095 | 2020-05-16 | Gove | Kansas | 20063 | 1 | 0 |
152106 | 152106 | 2020-05-17 | Gove | Kansas | 20063 | 1 | 0 |
155118 | 155118 | 2020-05-18 | Gove | Kansas | 20063 | 1 | 0 |
158135 | 158135 | 2020-05-19 | Gove | Kansas | 20063 | 1 | 0 |
161160 | 161160 | 2020-05-20 | Gove | Kansas | 20063 | 1 | 0 |
164189 | 164189 | 2020-05-21 | Gove | Kansas | 20063 | 1 | 0 |
167222 | 167222 | 2020-05-22 | Gove | Kansas | 20063 | 1 | 0 |
170260 | 170260 | 2020-05-23 | Gove | Kansas | 20063 | 1 | 0 |
173301 | 173301 | 2020-05-24 | Gove | Kansas | 20063 | 1 | 0 |
176345 | 176345 | 2020-05-25 | Gove | Kansas | 20063 | 1 | 0 |
179389 | 179389 | 2020-05-26 | Gove | Kansas | 20063 | 1 | 0 |
182434 | 182434 | 2020-05-27 | Gove | Kansas | 20063 | 1 | 0 |
185488 | 185488 | 2020-05-28 | Gove | Kansas | 20063 | 1 | 0 |
188546 | 188546 | 2020-05-29 | Gove | Kansas | 20063 | 1 | 0 |
191610 | 191610 | 2020-05-30 | Gove | Kansas | 20063 | 1 | 0 |
194678 | 194678 | 2020-05-31 | Gove | Kansas | 20063 | 1 | 0 |
197748 | 197748 | 2020-06-01 | Gove | Kansas | 20063 | 1 | 0 |
200820 | 200820 | 2020-06-02 | Gove | Kansas | 20063 | 1 | 0 |
203896 | 203896 | 2020-06-03 | Gove | Kansas | 20063 | 1 | 0 |
206977 | 206977 | 2020-06-04 | Gove | Kansas | 20063 | 1 | 0 |
210058 | 210058 | 2020-06-05 | Gove | Kansas | 20063 | 1 | 0 |
213143 | 213143 | 2020-06-06 | Gove | Kansas | 20063 | 1 | 0 |
216230 | 216230 | 2020-06-07 | Gove | Kansas | 20063 | 1 | 0 |
219322 | 219322 | 2020-06-08 | Gove | Kansas | 20063 | 1 | 0 |
222417 | 222417 | 2020-06-09 | Gove | Kansas | 20063 | 1 | 0 |
225512 | 225512 | 2020-06-10 | Gove | Kansas | 20063 | 1 | 0 |
228614 | 228614 | 2020-06-11 | Gove | Kansas | 20063 | 1 | 0 |
231717 | 231717 | 2020-06-12 | Gove | Kansas | 20063 | 1 | 0 |
234823 | 234823 | 2020-06-13 | Gove | Kansas | 20063 | 1 | 0 |
237930 | 237930 | 2020-06-14 | Gove | Kansas | 20063 | 1 | 0 |
241039 | 241039 | 2020-06-15 | Gove | Kansas | 20063 | 1 | 0 |
244150 | 244150 | 2020-06-16 | Gove | Kansas | 20063 | 1 | 0 |
247263 | 247263 | 2020-06-17 | Gove | Kansas | 20063 | 1 | 0 |
250375 | 250375 | 2020-06-18 | Gove | Kansas | 20063 | 1 | 0 |
253490 | 253490 | 2020-06-19 | Gove | Kansas | 20063 | 1 | 0 |
256610 | 256610 | 2020-06-20 | Gove | Kansas | 20063 | 1 | 0 |
259736 | 259736 | 2020-06-21 | Gove | Kansas | 20063 | 1 | 0 |
262863 | 262863 | 2020-06-22 | Gove | Kansas | 20063 | 1 | 0 |
265991 | 265991 | 2020-06-23 | Gove | Kansas | 20063 | 1 | 0 |
269121 | 269121 | 2020-06-24 | Gove | Kansas | 20063 | 1 | 0 |
272258 | 272258 | 2020-06-25 | Gove | Kansas | 20063 | 1 | 0 |
275401 | 275401 | 2020-06-26 | Gove | Kansas | 20063 | 1 | 0 |
278549 | 278549 | 2020-06-27 | Gove | Kansas | 20063 | 1 | 0 |
281697 | 281697 | 2020-06-28 | Gove | Kansas | 20063 | 1 | 0 |
284842 | 284842 | 2020-06-29 | Gove | Kansas | 20063 | 1 | 0 |
287991 | 287991 | 2020-06-30 | Gove | Kansas | 20063 | 1 | 0 |
291141 | 291141 | 2020-07-01 | Gove | Kansas | 20063 | 1 | 0 |
294295 | 294295 | 2020-07-02 | Gove | Kansas | 20063 | 1 | 0 |
297453 | 297453 | 2020-07-03 | Gove | Kansas | 20063 | 2 | 0 |
300615 | 300615 | 2020-07-04 | Gove | Kansas | 20063 | 2 | 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);