ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,807 rows where county = "Brown" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Brown · 6,807 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
104434 | 104434 | 2020-05-01 | Brown | Illinois | 17009 | 1 | 0 |
107299 | 107299 | 2020-05-02 | Brown | Illinois | 17009 | 1 | 0 |
110169 | 110169 | 2020-05-03 | Brown | Illinois | 17009 | 1 | 0 |
113044 | 113044 | 2020-05-04 | Brown | Illinois | 17009 | 2 | 0 |
115927 | 115927 | 2020-05-05 | Brown | Illinois | 17009 | 2 | 0 |
118887 | 118887 | 2020-05-06 | Brown | Illinois | 17009 | 6 | 0 |
121857 | 121857 | 2020-05-07 | Brown | Illinois | 17009 | 6 | 0 |
124836 | 124836 | 2020-05-08 | Brown | Illinois | 17009 | 6 | 0 |
127823 | 127823 | 2020-05-09 | Brown | Illinois | 17009 | 8 | 0 |
130814 | 130814 | 2020-05-10 | Brown | Illinois | 17009 | 8 | 0 |
133805 | 133805 | 2020-05-11 | Brown | Illinois | 17009 | 9 | 0 |
136794 | 136794 | 2020-05-12 | Brown | Illinois | 17009 | 9 | 0 |
139785 | 139785 | 2020-05-13 | Brown | Illinois | 17009 | 9 | 0 |
142781 | 142781 | 2020-05-14 | Brown | Illinois | 17009 | 9 | 0 |
145781 | 145781 | 2020-05-15 | Brown | Illinois | 17009 | 9 | 0 |
148784 | 148784 | 2020-05-16 | Brown | Illinois | 17009 | 10 | 0 |
151793 | 151793 | 2020-05-17 | Brown | Illinois | 17009 | 10 | 0 |
154805 | 154805 | 2020-05-18 | Brown | Illinois | 17009 | 11 | 0 |
157821 | 157821 | 2020-05-19 | Brown | Illinois | 17009 | 10 | 0 |
160847 | 160847 | 2020-05-20 | Brown | Illinois | 17009 | 10 | 0 |
163875 | 163875 | 2020-05-21 | Brown | Illinois | 17009 | 10 | 0 |
166908 | 166908 | 2020-05-22 | Brown | Illinois | 17009 | 10 | 0 |
169945 | 169945 | 2020-05-23 | Brown | Illinois | 17009 | 10 | 0 |
172986 | 172986 | 2020-05-24 | Brown | Illinois | 17009 | 10 | 0 |
176030 | 176030 | 2020-05-25 | Brown | Illinois | 17009 | 10 | 0 |
179074 | 179074 | 2020-05-26 | Brown | Illinois | 17009 | 10 | 0 |
182118 | 182118 | 2020-05-27 | Brown | Illinois | 17009 | 10 | 0 |
185172 | 185172 | 2020-05-28 | Brown | Illinois | 17009 | 10 | 0 |
188229 | 188229 | 2020-05-29 | Brown | Illinois | 17009 | 10 | 0 |
191294 | 191294 | 2020-05-30 | Brown | Illinois | 17009 | 10 | 0 |
194361 | 194361 | 2020-05-31 | Brown | Illinois | 17009 | 10 | 0 |
197431 | 197431 | 2020-06-01 | Brown | Illinois | 17009 | 10 | 0 |
200504 | 200504 | 2020-06-02 | Brown | Illinois | 17009 | 10 | 0 |
203580 | 203580 | 2020-06-03 | Brown | Illinois | 17009 | 10 | 0 |
206660 | 206660 | 2020-06-04 | Brown | Illinois | 17009 | 10 | 0 |
209741 | 209741 | 2020-06-05 | Brown | Illinois | 17009 | 10 | 0 |
212826 | 212826 | 2020-06-06 | Brown | Illinois | 17009 | 10 | 0 |
215913 | 215913 | 2020-06-07 | Brown | Illinois | 17009 | 10 | 0 |
219004 | 219004 | 2020-06-08 | Brown | Illinois | 17009 | 10 | 0 |
222099 | 222099 | 2020-06-09 | Brown | Illinois | 17009 | 10 | 0 |
225194 | 225194 | 2020-06-10 | Brown | Illinois | 17009 | 10 | 0 |
228296 | 228296 | 2020-06-11 | Brown | Illinois | 17009 | 10 | 0 |
231399 | 231399 | 2020-06-12 | Brown | Illinois | 17009 | 10 | 0 |
234505 | 234505 | 2020-06-13 | Brown | Illinois | 17009 | 10 | 0 |
237612 | 237612 | 2020-06-14 | Brown | Illinois | 17009 | 10 | 0 |
240720 | 240720 | 2020-06-15 | Brown | Illinois | 17009 | 10 | 0 |
243831 | 243831 | 2020-06-16 | Brown | Illinois | 17009 | 10 | 0 |
246944 | 246944 | 2020-06-17 | Brown | Illinois | 17009 | 10 | 0 |
250056 | 250056 | 2020-06-18 | Brown | Illinois | 17009 | 10 | 0 |
253171 | 253171 | 2020-06-19 | Brown | Illinois | 17009 | 10 | 0 |
256291 | 256291 | 2020-06-20 | Brown | Illinois | 17009 | 10 | 0 |
259417 | 259417 | 2020-06-21 | Brown | Illinois | 17009 | 10 | 0 |
262544 | 262544 | 2020-06-22 | Brown | Illinois | 17009 | 10 | 0 |
265672 | 265672 | 2020-06-23 | Brown | Illinois | 17009 | 10 | 0 |
268802 | 268802 | 2020-06-24 | Brown | Illinois | 17009 | 10 | 0 |
271939 | 271939 | 2020-06-25 | Brown | Illinois | 17009 | 10 | 0 |
275081 | 275081 | 2020-06-26 | Brown | Illinois | 17009 | 10 | 0 |
278229 | 278229 | 2020-06-27 | Brown | Illinois | 17009 | 10 | 0 |
281377 | 281377 | 2020-06-28 | Brown | Illinois | 17009 | 10 | 0 |
284522 | 284522 | 2020-06-29 | Brown | Illinois | 17009 | 10 | 0 |
287671 | 287671 | 2020-06-30 | Brown | Illinois | 17009 | 10 | 0 |
290821 | 290821 | 2020-07-01 | Brown | Illinois | 17009 | 10 | 0 |
293975 | 293975 | 2020-07-02 | Brown | Illinois | 17009 | 10 | 0 |
297132 | 297132 | 2020-07-03 | Brown | Illinois | 17009 | 10 | 0 |
300294 | 300294 | 2020-07-04 | Brown | Illinois | 17009 | 10 | 0 |
303458 | 303458 | 2020-07-05 | Brown | Illinois | 17009 | 10 | 0 |
306623 | 306623 | 2020-07-06 | Brown | Illinois | 17009 | 10 | 0 |
309791 | 309791 | 2020-07-07 | Brown | Illinois | 17009 | 10 | 0 |
312961 | 312961 | 2020-07-08 | Brown | Illinois | 17009 | 10 | 0 |
316135 | 316135 | 2020-07-09 | Brown | Illinois | 17009 | 10 | 0 |
319308 | 319308 | 2020-07-10 | Brown | Illinois | 17009 | 10 | 0 |
322487 | 322487 | 2020-07-11 | Brown | Illinois | 17009 | 10 | 0 |
325668 | 325668 | 2020-07-12 | Brown | Illinois | 17009 | 10 | 0 |
328854 | 328854 | 2020-07-13 | Brown | Illinois | 17009 | 10 | 0 |
332041 | 332041 | 2020-07-14 | Brown | Illinois | 17009 | 10 | 0 |
335234 | 335234 | 2020-07-15 | Brown | Illinois | 17009 | 10 | 0 |
338430 | 338430 | 2020-07-16 | Brown | Illinois | 17009 | 10 | 0 |
341626 | 341626 | 2020-07-17 | Brown | Illinois | 17009 | 10 | 0 |
344826 | 344826 | 2020-07-18 | Brown | Illinois | 17009 | 10 | 0 |
348027 | 348027 | 2020-07-19 | Brown | Illinois | 17009 | 11 | 0 |
351227 | 351227 | 2020-07-20 | Brown | Illinois | 17009 | 11 | 0 |
354429 | 354429 | 2020-07-21 | Brown | Illinois | 17009 | 11 | 0 |
357631 | 357631 | 2020-07-22 | Brown | Illinois | 17009 | 11 | 0 |
360836 | 360836 | 2020-07-23 | Brown | Illinois | 17009 | 12 | 0 |
364043 | 364043 | 2020-07-24 | Brown | Illinois | 17009 | 12 | 0 |
367250 | 367250 | 2020-07-25 | Brown | Illinois | 17009 | 12 | 0 |
370460 | 370460 | 2020-07-26 | Brown | Illinois | 17009 | 12 | 0 |
373672 | 373672 | 2020-07-27 | Brown | Illinois | 17009 | 12 | 0 |
376887 | 376887 | 2020-07-28 | Brown | Illinois | 17009 | 12 | 0 |
380104 | 380104 | 2020-07-29 | Brown | Illinois | 17009 | 13 | 0 |
383321 | 383321 | 2020-07-30 | Brown | Illinois | 17009 | 13 | 0 |
386539 | 386539 | 2020-07-31 | Brown | Illinois | 17009 | 13 | 0 |
389756 | 389756 | 2020-08-01 | Brown | Illinois | 17009 | 13 | 0 |
392973 | 392973 | 2020-08-02 | Brown | Illinois | 17009 | 13 | 0 |
396189 | 396189 | 2020-08-03 | Brown | Illinois | 17009 | 13 | 0 |
399405 | 399405 | 2020-08-04 | Brown | Illinois | 17009 | 13 | 0 |
402621 | 402621 | 2020-08-05 | Brown | Illinois | 17009 | 13 | 0 |
405839 | 405839 | 2020-08-06 | Brown | Illinois | 17009 | 13 | 0 |
409059 | 409059 | 2020-08-07 | Brown | Illinois | 17009 | 13 | 0 |
412278 | 412278 | 2020-08-08 | Brown | Illinois | 17009 | 13 | 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);