ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Johnson", fips = 31097 and state = "Nebraska" 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 |
---|---|---|---|---|---|---|---|
34497 | 34497 | 2020-04-05 | Johnson | Nebraska | 31097 | 1 | 0 |
36966 | 36966 | 2020-04-06 | Johnson | Nebraska | 31097 | 1 | 0 |
39482 | 39482 | 2020-04-07 | Johnson | Nebraska | 31097 | 1 | 0 |
42038 | 42038 | 2020-04-08 | Johnson | Nebraska | 31097 | 1 | 0 |
44619 | 44619 | 2020-04-09 | Johnson | Nebraska | 31097 | 1 | 0 |
47231 | 47231 | 2020-04-10 | Johnson | Nebraska | 31097 | 1 | 0 |
49881 | 49881 | 2020-04-11 | Johnson | Nebraska | 31097 | 1 | 0 |
52555 | 52555 | 2020-04-12 | Johnson | Nebraska | 31097 | 1 | 0 |
55236 | 55236 | 2020-04-13 | Johnson | Nebraska | 31097 | 1 | 0 |
57935 | 57935 | 2020-04-14 | Johnson | Nebraska | 31097 | 1 | 0 |
60649 | 60649 | 2020-04-15 | Johnson | Nebraska | 31097 | 1 | 0 |
63373 | 63373 | 2020-04-16 | Johnson | Nebraska | 31097 | 2 | 0 |
66114 | 66114 | 2020-04-17 | Johnson | Nebraska | 31097 | 2 | 0 |
68869 | 68869 | 2020-04-18 | Johnson | Nebraska | 31097 | 2 | 0 |
71636 | 71636 | 2020-04-19 | Johnson | Nebraska | 31097 | 2 | 0 |
74410 | 74410 | 2020-04-20 | Johnson | Nebraska | 31097 | 2 | 0 |
77190 | 77190 | 2020-04-21 | Johnson | Nebraska | 31097 | 2 | 0 |
79979 | 79979 | 2020-04-22 | Johnson | Nebraska | 31097 | 2 | 0 |
82776 | 82776 | 2020-04-23 | Johnson | Nebraska | 31097 | 2 | 0 |
85581 | 85581 | 2020-04-24 | Johnson | Nebraska | 31097 | 2 | 0 |
88391 | 88391 | 2020-04-25 | Johnson | Nebraska | 31097 | 2 | 0 |
91207 | 91207 | 2020-04-26 | Johnson | Nebraska | 31097 | 4 | 0 |
94029 | 94029 | 2020-04-27 | Johnson | Nebraska | 31097 | 4 | 0 |
96865 | 96865 | 2020-04-28 | Johnson | Nebraska | 31097 | 4 | 0 |
99712 | 99712 | 2020-04-29 | Johnson | Nebraska | 31097 | 4 | 0 |
102565 | 102565 | 2020-04-30 | Johnson | Nebraska | 31097 | 4 | 0 |
105426 | 105426 | 2020-05-01 | Johnson | Nebraska | 31097 | 4 | 0 |
108292 | 108292 | 2020-05-02 | Johnson | Nebraska | 31097 | 4 | 0 |
111165 | 111165 | 2020-05-03 | Johnson | Nebraska | 31097 | 4 | 0 |
114045 | 114045 | 2020-05-04 | Johnson | Nebraska | 31097 | 4 | 0 |
116927 | 116927 | 2020-05-05 | Johnson | Nebraska | 31097 | 4 | 0 |
119887 | 119887 | 2020-05-06 | Johnson | Nebraska | 31097 | 4 | 0 |
122861 | 122861 | 2020-05-07 | Johnson | Nebraska | 31097 | 4 | 0 |
125843 | 125843 | 2020-05-08 | Johnson | Nebraska | 31097 | 5 | 0 |
128832 | 128832 | 2020-05-09 | Johnson | Nebraska | 31097 | 5 | 0 |
131822 | 131822 | 2020-05-10 | Johnson | Nebraska | 31097 | 5 | 0 |
134813 | 134813 | 2020-05-11 | Johnson | Nebraska | 31097 | 5 | 0 |
137803 | 137803 | 2020-05-12 | Johnson | Nebraska | 31097 | 5 | 0 |
140797 | 140797 | 2020-05-13 | Johnson | Nebraska | 31097 | 5 | 0 |
143792 | 143792 | 2020-05-14 | Johnson | Nebraska | 31097 | 5 | 0 |
146793 | 146793 | 2020-05-15 | Johnson | Nebraska | 31097 | 6 | 0 |
149799 | 149799 | 2020-05-16 | Johnson | Nebraska | 31097 | 6 | 0 |
152810 | 152810 | 2020-05-17 | Johnson | Nebraska | 31097 | 7 | 0 |
155824 | 155824 | 2020-05-18 | Johnson | Nebraska | 31097 | 7 | 0 |
158842 | 158842 | 2020-05-19 | Johnson | Nebraska | 31097 | 7 | 0 |
161868 | 161868 | 2020-05-20 | Johnson | Nebraska | 31097 | 7 | 0 |
164897 | 164897 | 2020-05-21 | Johnson | Nebraska | 31097 | 7 | 0 |
167933 | 167933 | 2020-05-22 | Johnson | Nebraska | 31097 | 7 | 0 |
170972 | 170972 | 2020-05-23 | Johnson | Nebraska | 31097 | 7 | 0 |
174015 | 174015 | 2020-05-24 | Johnson | Nebraska | 31097 | 7 | 0 |
177058 | 177058 | 2020-05-25 | Johnson | Nebraska | 31097 | 7 | 0 |
180102 | 180102 | 2020-05-26 | Johnson | Nebraska | 31097 | 7 | 0 |
183150 | 183150 | 2020-05-27 | Johnson | Nebraska | 31097 | 7 | 0 |
186206 | 186206 | 2020-05-28 | Johnson | Nebraska | 31097 | 7 | 0 |
189265 | 189265 | 2020-05-29 | Johnson | Nebraska | 31097 | 6 | 0 |
192329 | 192329 | 2020-05-30 | Johnson | Nebraska | 31097 | 6 | 0 |
195399 | 195399 | 2020-05-31 | Johnson | Nebraska | 31097 | 6 | 0 |
198472 | 198472 | 2020-06-01 | Johnson | Nebraska | 31097 | 6 | 0 |
201546 | 201546 | 2020-06-02 | Johnson | Nebraska | 31097 | 6 | 0 |
204623 | 204623 | 2020-06-03 | Johnson | Nebraska | 31097 | 6 | 0 |
207704 | 207704 | 2020-06-04 | Johnson | Nebraska | 31097 | 6 | 0 |
210786 | 210786 | 2020-06-05 | Johnson | Nebraska | 31097 | 6 | 0 |
213870 | 213870 | 2020-06-06 | Johnson | Nebraska | 31097 | 6 | 0 |
216959 | 216959 | 2020-06-07 | Johnson | Nebraska | 31097 | 6 | 0 |
220051 | 220051 | 2020-06-08 | Johnson | Nebraska | 31097 | 6 | 0 |
223147 | 223147 | 2020-06-09 | Johnson | Nebraska | 31097 | 6 | 0 |
226246 | 226246 | 2020-06-10 | Johnson | Nebraska | 31097 | 6 | 0 |
229349 | 229349 | 2020-06-11 | Johnson | Nebraska | 31097 | 6 | 0 |
232454 | 232454 | 2020-06-12 | Johnson | Nebraska | 31097 | 6 | 0 |
235560 | 235560 | 2020-06-13 | Johnson | Nebraska | 31097 | 6 | 0 |
238667 | 238667 | 2020-06-14 | Johnson | Nebraska | 31097 | 6 | 0 |
241777 | 241777 | 2020-06-15 | Johnson | Nebraska | 31097 | 6 | 0 |
244888 | 244888 | 2020-06-16 | Johnson | Nebraska | 31097 | 6 | 0 |
248001 | 248001 | 2020-06-17 | Johnson | Nebraska | 31097 | 6 | 0 |
251116 | 251116 | 2020-06-18 | Johnson | Nebraska | 31097 | 6 | 0 |
254231 | 254231 | 2020-06-19 | Johnson | Nebraska | 31097 | 6 | 0 |
257354 | 257354 | 2020-06-20 | Johnson | Nebraska | 31097 | 6 | 0 |
260480 | 260480 | 2020-06-21 | Johnson | Nebraska | 31097 | 6 | 0 |
263609 | 263609 | 2020-06-22 | Johnson | Nebraska | 31097 | 6 | 0 |
266736 | 266736 | 2020-06-23 | Johnson | Nebraska | 31097 | 6 | 0 |
269870 | 269870 | 2020-06-24 | Johnson | Nebraska | 31097 | 6 | 0 |
273009 | 273009 | 2020-06-25 | Johnson | Nebraska | 31097 | 6 | 0 |
276152 | 276152 | 2020-06-26 | Johnson | Nebraska | 31097 | 6 | 0 |
279300 | 279300 | 2020-06-27 | Johnson | Nebraska | 31097 | 6 | 0 |
282448 | 282448 | 2020-06-28 | Johnson | Nebraska | 31097 | 6 | 0 |
285593 | 285593 | 2020-06-29 | Johnson | Nebraska | 31097 | 6 | 0 |
288743 | 288743 | 2020-06-30 | Johnson | Nebraska | 31097 | 7 | 0 |
291895 | 291895 | 2020-07-01 | Johnson | Nebraska | 31097 | 7 | 0 |
295050 | 295050 | 2020-07-02 | Johnson | Nebraska | 31097 | 7 | 0 |
298209 | 298209 | 2020-07-03 | Johnson | Nebraska | 31097 | 7 | 0 |
301372 | 301372 | 2020-07-04 | Johnson | Nebraska | 31097 | 7 | 0 |
304536 | 304536 | 2020-07-05 | Johnson | Nebraska | 31097 | 7 | 0 |
307703 | 307703 | 2020-07-06 | Johnson | Nebraska | 31097 | 7 | 0 |
310871 | 310871 | 2020-07-07 | Johnson | Nebraska | 31097 | 7 | 0 |
314042 | 314042 | 2020-07-08 | Johnson | Nebraska | 31097 | 7 | 0 |
317216 | 317216 | 2020-07-09 | Johnson | Nebraska | 31097 | 7 | 0 |
320391 | 320391 | 2020-07-10 | Johnson | Nebraska | 31097 | 7 | 0 |
323570 | 323570 | 2020-07-11 | Johnson | Nebraska | 31097 | 8 | 0 |
326754 | 326754 | 2020-07-12 | Johnson | Nebraska | 31097 | 7 | 0 |
329941 | 329941 | 2020-07-13 | Johnson | Nebraska | 31097 | 7 | 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);