ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 20155 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5475 | 5475 | 2020-03-20 | Reno | Kansas | 20155 | 1 | 0 |
6420 | 6420 | 2020-03-21 | Reno | Kansas | 20155 | 1 | 0 |
7489 | 7489 | 2020-03-22 | Reno | Kansas | 20155 | 2 | 0 |
8651 | 8651 | 2020-03-23 | Reno | Kansas | 20155 | 2 | 0 |
9933 | 9933 | 2020-03-24 | Reno | Kansas | 20155 | 2 | 0 |
11332 | 11332 | 2020-03-25 | Reno | Kansas | 20155 | 2 | 0 |
12900 | 12900 | 2020-03-26 | Reno | Kansas | 20155 | 4 | 0 |
14603 | 14603 | 2020-03-27 | Reno | Kansas | 20155 | 5 | 0 |
16411 | 16411 | 2020-03-28 | Reno | Kansas | 20155 | 5 | 0 |
18318 | 18318 | 2020-03-29 | Reno | Kansas | 20155 | 7 | 0 |
20331 | 20331 | 2020-03-30 | Reno | Kansas | 20155 | 7 | 0 |
22430 | 22430 | 2020-03-31 | Reno | Kansas | 20155 | 7 | 0 |
24606 | 24606 | 2020-04-01 | Reno | Kansas | 20155 | 8 | 0 |
26850 | 26850 | 2020-04-02 | Reno | Kansas | 20155 | 8 | 0 |
29166 | 29166 | 2020-04-03 | Reno | Kansas | 20155 | 9 | 0 |
31540 | 31540 | 2020-04-04 | Reno | Kansas | 20155 | 9 | 0 |
33954 | 33954 | 2020-04-05 | Reno | Kansas | 20155 | 10 | 0 |
36412 | 36412 | 2020-04-06 | Reno | Kansas | 20155 | 10 | 0 |
38914 | 38914 | 2020-04-07 | Reno | Kansas | 20155 | 10 | 0 |
41461 | 41461 | 2020-04-08 | Reno | Kansas | 20155 | 11 | 0 |
44037 | 44037 | 2020-04-09 | Reno | Kansas | 20155 | 11 | 0 |
46644 | 46644 | 2020-04-10 | Reno | Kansas | 20155 | 11 | 0 |
49281 | 49281 | 2020-04-11 | Reno | Kansas | 20155 | 11 | 0 |
51946 | 51946 | 2020-04-12 | Reno | Kansas | 20155 | 11 | 0 |
54628 | 54628 | 2020-04-13 | Reno | Kansas | 20155 | 13 | 0 |
57322 | 57322 | 2020-04-14 | Reno | Kansas | 20155 | 14 | 0 |
60030 | 60030 | 2020-04-15 | Reno | Kansas | 20155 | 14 | 0 |
62751 | 62751 | 2020-04-16 | Reno | Kansas | 20155 | 14 | 0 |
65487 | 65487 | 2020-04-17 | Reno | Kansas | 20155 | 14 | 0 |
68236 | 68236 | 2020-04-18 | Reno | Kansas | 20155 | 14 | 0 |
70997 | 70997 | 2020-04-19 | Reno | Kansas | 20155 | 14 | 0 |
73769 | 73769 | 2020-04-20 | Reno | Kansas | 20155 | 14 | 0 |
76549 | 76549 | 2020-04-21 | Reno | Kansas | 20155 | 15 | 0 |
79334 | 79334 | 2020-04-22 | Reno | Kansas | 20155 | 15 | 0 |
82129 | 82129 | 2020-04-23 | Reno | Kansas | 20155 | 16 | 0 |
84932 | 84932 | 2020-04-24 | Reno | Kansas | 20155 | 16 | 0 |
87741 | 87741 | 2020-04-25 | Reno | Kansas | 20155 | 21 | 0 |
90557 | 90557 | 2020-04-26 | Reno | Kansas | 20155 | 23 | 0 |
93378 | 93378 | 2020-04-27 | Reno | Kansas | 20155 | 27 | 0 |
96211 | 96211 | 2020-04-28 | Reno | Kansas | 20155 | 27 | 0 |
99057 | 99057 | 2020-04-29 | Reno | Kansas | 20155 | 32 | 0 |
101909 | 101909 | 2020-04-30 | Reno | Kansas | 20155 | 34 | 0 |
104770 | 104770 | 2020-05-01 | Reno | Kansas | 20155 | 36 | 0 |
107635 | 107635 | 2020-05-02 | Reno | Kansas | 20155 | 38 | 0 |
110506 | 110506 | 2020-05-03 | Reno | Kansas | 20155 | 40 | 0 |
113383 | 113383 | 2020-05-04 | Reno | Kansas | 20155 | 40 | 0 |
116265 | 116265 | 2020-05-05 | Reno | Kansas | 20155 | 40 | 0 |
119226 | 119226 | 2020-05-06 | Reno | Kansas | 20155 | 40 | 0 |
122196 | 122196 | 2020-05-07 | Reno | Kansas | 20155 | 44 | 0 |
140130 | 140130 | 2020-05-13 | Reno | Kansas | 20155 | 51 | 0 |
143126 | 143126 | 2020-05-14 | Reno | Kansas | 20155 | 51 | 0 |
146126 | 146126 | 2020-05-15 | Reno | Kansas | 20155 | 51 | 0 |
149130 | 149130 | 2020-05-16 | Reno | Kansas | 20155 | 51 | 0 |
152141 | 152141 | 2020-05-17 | Reno | Kansas | 20155 | 51 | 0 |
155154 | 155154 | 2020-05-18 | Reno | Kansas | 20155 | 51 | 0 |
158171 | 158171 | 2020-05-19 | Reno | Kansas | 20155 | 51 | 0 |
161196 | 161196 | 2020-05-20 | Reno | Kansas | 20155 | 51 | 0 |
164225 | 164225 | 2020-05-21 | Reno | Kansas | 20155 | 51 | 0 |
167260 | 167260 | 2020-05-22 | Reno | Kansas | 20155 | 51 | 0 |
170298 | 170298 | 2020-05-23 | Reno | Kansas | 20155 | 51 | 0 |
173339 | 173339 | 2020-05-24 | Reno | Kansas | 20155 | 51 | 0 |
182472 | 182472 | 2020-05-27 | Reno | Kansas | 20155 | 51 | 0 |
185526 | 185526 | 2020-05-28 | Reno | Kansas | 20155 | 51 | 0 |
188584 | 188584 | 2020-05-29 | Reno | Kansas | 20155 | 51 | 0 |
191648 | 191648 | 2020-05-30 | Reno | Kansas | 20155 | 51 | 0 |
194716 | 194716 | 2020-05-31 | Reno | Kansas | 20155 | 51 | 0 |
197786 | 197786 | 2020-06-01 | Reno | Kansas | 20155 | 51 | 0 |
200858 | 200858 | 2020-06-02 | Reno | Kansas | 20155 | 51 | 0 |
203935 | 203935 | 2020-06-03 | Reno | Kansas | 20155 | 51 | 0 |
207016 | 207016 | 2020-06-04 | Reno | Kansas | 20155 | 51 | 0 |
125178 | 125178 | 2020-05-08 | Reno | Kansas | 20155 | 52 | 0 |
128166 | 128166 | 2020-05-09 | Reno | Kansas | 20155 | 52 | 0 |
134147 | 134147 | 2020-05-11 | Reno | Kansas | 20155 | 52 | 0 |
137137 | 137137 | 2020-05-12 | Reno | Kansas | 20155 | 52 | 0 |
176383 | 176383 | 2020-05-25 | Reno | Kansas | 20155 | 52 | 0 |
179427 | 179427 | 2020-05-26 | Reno | Kansas | 20155 | 52 | 0 |
131156 | 131156 | 2020-05-10 | Reno | Kansas | 20155 | 53 | 0 |
210097 | 210097 | 2020-06-05 | Reno | Kansas | 20155 | 53 | 0 |
213182 | 213182 | 2020-06-06 | Reno | Kansas | 20155 | 53 | 0 |
216269 | 216269 | 2020-06-07 | Reno | Kansas | 20155 | 53 | 0 |
219361 | 219361 | 2020-06-08 | Reno | Kansas | 20155 | 54 | 0 |
222456 | 222456 | 2020-06-09 | Reno | Kansas | 20155 | 54 | 0 |
225551 | 225551 | 2020-06-10 | Reno | Kansas | 20155 | 55 | 0 |
228653 | 228653 | 2020-06-11 | Reno | Kansas | 20155 | 55 | 0 |
231756 | 231756 | 2020-06-12 | Reno | Kansas | 20155 | 56 | 0 |
234862 | 234862 | 2020-06-13 | Reno | Kansas | 20155 | 56 | 0 |
237969 | 237969 | 2020-06-14 | Reno | Kansas | 20155 | 56 | 0 |
241078 | 241078 | 2020-06-15 | Reno | Kansas | 20155 | 57 | 0 |
244189 | 244189 | 2020-06-16 | Reno | Kansas | 20155 | 57 | 0 |
247302 | 247302 | 2020-06-17 | Reno | Kansas | 20155 | 58 | 0 |
250414 | 250414 | 2020-06-18 | Reno | Kansas | 20155 | 58 | 0 |
253529 | 253529 | 2020-06-19 | Reno | Kansas | 20155 | 58 | 0 |
256649 | 256649 | 2020-06-20 | Reno | Kansas | 20155 | 58 | 0 |
259775 | 259775 | 2020-06-21 | Reno | Kansas | 20155 | 58 | 0 |
262902 | 262902 | 2020-06-22 | Reno | Kansas | 20155 | 63 | 0 |
266030 | 266030 | 2020-06-23 | Reno | Kansas | 20155 | 63 | 0 |
269162 | 269162 | 2020-06-24 | Reno | Kansas | 20155 | 67 | 0 |
272299 | 272299 | 2020-06-25 | Reno | Kansas | 20155 | 67 | 0 |
275442 | 275442 | 2020-06-26 | Reno | Kansas | 20155 | 69 | 0 |
278590 | 278590 | 2020-06-27 | Reno | Kansas | 20155 | 69 | 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);