ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Brown" and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
5937 | 5937 | 2020-03-20 | Brown | Texas | 48049 | 1 | 0 |
6955 | 6955 | 2020-03-21 | Brown | Texas | 48049 | 2 | 0 |
8085 | 8085 | 2020-03-22 | Brown | Texas | 48049 | 2 | 0 |
9303 | 9303 | 2020-03-23 | Brown | Texas | 48049 | 2 | 0 |
10637 | 10637 | 2020-03-24 | Brown | Texas | 48049 | 2 | 0 |
12120 | 12120 | 2020-03-25 | Brown | Texas | 48049 | 2 | 0 |
13748 | 13748 | 2020-03-26 | Brown | Texas | 48049 | 3 | 0 |
15501 | 15501 | 2020-03-27 | Brown | Texas | 48049 | 3 | 0 |
17368 | 17368 | 2020-03-28 | Brown | Texas | 48049 | 3 | 0 |
19318 | 19318 | 2020-03-29 | Brown | Texas | 48049 | 3 | 0 |
21377 | 21377 | 2020-03-30 | Brown | Texas | 48049 | 3 | 0 |
23516 | 23516 | 2020-03-31 | Brown | Texas | 48049 | 3 | 0 |
25720 | 25720 | 2020-04-01 | Brown | Texas | 48049 | 3 | 0 |
28000 | 28000 | 2020-04-02 | Brown | Texas | 48049 | 3 | 0 |
30335 | 30335 | 2020-04-03 | Brown | Texas | 48049 | 4 | 0 |
32728 | 32728 | 2020-04-04 | Brown | Texas | 48049 | 4 | 0 |
35166 | 35166 | 2020-04-05 | Brown | Texas | 48049 | 5 | 0 |
37642 | 37642 | 2020-04-06 | Brown | Texas | 48049 | 5 | 0 |
40164 | 40164 | 2020-04-07 | Brown | Texas | 48049 | 6 | 0 |
42727 | 42727 | 2020-04-08 | Brown | Texas | 48049 | 6 | 0 |
45316 | 45316 | 2020-04-09 | Brown | Texas | 48049 | 8 | 0 |
47934 | 47934 | 2020-04-10 | Brown | Texas | 48049 | 8 | 0 |
50591 | 50591 | 2020-04-11 | Brown | Texas | 48049 | 10 | 0 |
53266 | 53266 | 2020-04-12 | Brown | Texas | 48049 | 10 | 0 |
55954 | 55954 | 2020-04-13 | Brown | Texas | 48049 | 10 | 1 |
58658 | 58658 | 2020-04-14 | Brown | Texas | 48049 | 11 | 1 |
61375 | 61375 | 2020-04-15 | Brown | Texas | 48049 | 11 | 1 |
64102 | 64102 | 2020-04-16 | Brown | Texas | 48049 | 12 | 1 |
66849 | 66849 | 2020-04-17 | Brown | Texas | 48049 | 12 | 1 |
69608 | 69608 | 2020-04-18 | Brown | Texas | 48049 | 12 | 1 |
72375 | 72375 | 2020-04-19 | Brown | Texas | 48049 | 13 | 1 |
75150 | 75150 | 2020-04-20 | Brown | Texas | 48049 | 13 | 1 |
77932 | 77932 | 2020-04-21 | Brown | Texas | 48049 | 13 | 1 |
80723 | 80723 | 2020-04-22 | Brown | Texas | 48049 | 13 | 1 |
83522 | 83522 | 2020-04-23 | Brown | Texas | 48049 | 13 | 1 |
86327 | 86327 | 2020-04-24 | Brown | Texas | 48049 | 17 | 1 |
89142 | 89142 | 2020-04-25 | Brown | Texas | 48049 | 17 | 1 |
91959 | 91959 | 2020-04-26 | Brown | Texas | 48049 | 17 | 1 |
94787 | 94787 | 2020-04-27 | Brown | Texas | 48049 | 28 | 2 |
97627 | 97627 | 2020-04-28 | Brown | Texas | 48049 | 34 | 3 |
100477 | 100477 | 2020-04-29 | Brown | Texas | 48049 | 34 | 3 |
103330 | 103330 | 2020-04-30 | Brown | Texas | 48049 | 36 | 4 |
106194 | 106194 | 2020-05-01 | Brown | Texas | 48049 | 36 | 4 |
109062 | 109062 | 2020-05-02 | Brown | Texas | 48049 | 36 | 5 |
111936 | 111936 | 2020-05-03 | Brown | Texas | 48049 | 36 | 5 |
114818 | 114818 | 2020-05-04 | Brown | Texas | 48049 | 36 | 5 |
117775 | 117775 | 2020-05-05 | Brown | Texas | 48049 | 38 | 6 |
120739 | 120739 | 2020-05-06 | Brown | Texas | 48049 | 38 | 6 |
123718 | 123718 | 2020-05-07 | Brown | Texas | 48049 | 38 | 6 |
126701 | 126701 | 2020-05-08 | Brown | Texas | 48049 | 38 | 6 |
129690 | 129690 | 2020-05-09 | Brown | Texas | 48049 | 38 | 6 |
132680 | 132680 | 2020-05-10 | Brown | Texas | 48049 | 38 | 6 |
135671 | 135671 | 2020-05-11 | Brown | Texas | 48049 | 38 | 6 |
138661 | 138661 | 2020-05-12 | Brown | Texas | 48049 | 38 | 6 |
141657 | 141657 | 2020-05-13 | Brown | Texas | 48049 | 51 | 7 |
144654 | 144654 | 2020-05-14 | Brown | Texas | 48049 | 51 | 7 |
147656 | 147656 | 2020-05-15 | Brown | Texas | 48049 | 51 | 7 |
150664 | 150664 | 2020-05-16 | Brown | Texas | 48049 | 51 | 7 |
153675 | 153675 | 2020-05-17 | Brown | Texas | 48049 | 51 | 7 |
156692 | 156692 | 2020-05-18 | Brown | Texas | 48049 | 51 | 7 |
159714 | 159714 | 2020-05-19 | Brown | Texas | 48049 | 51 | 7 |
162741 | 162741 | 2020-05-20 | Brown | Texas | 48049 | 55 | 7 |
165770 | 165770 | 2020-05-21 | Brown | Texas | 48049 | 55 | 7 |
168806 | 168806 | 2020-05-22 | Brown | Texas | 48049 | 55 | 7 |
171845 | 171845 | 2020-05-23 | Brown | Texas | 48049 | 56 | 8 |
174888 | 174888 | 2020-05-24 | Brown | Texas | 48049 | 56 | 8 |
177932 | 177932 | 2020-05-25 | Brown | Texas | 48049 | 56 | 8 |
180975 | 180975 | 2020-05-26 | Brown | Texas | 48049 | 57 | 9 |
184025 | 184025 | 2020-05-27 | Brown | Texas | 48049 | 57 | 9 |
187082 | 187082 | 2020-05-28 | Brown | Texas | 48049 | 57 | 9 |
190146 | 190146 | 2020-05-29 | Brown | Texas | 48049 | 58 | 9 |
193211 | 193211 | 2020-05-30 | Brown | Texas | 48049 | 58 | 9 |
196281 | 196281 | 2020-05-31 | Brown | Texas | 48049 | 58 | 9 |
199354 | 199354 | 2020-06-01 | Brown | Texas | 48049 | 58 | 9 |
202429 | 202429 | 2020-06-02 | Brown | Texas | 48049 | 59 | 10 |
205508 | 205508 | 2020-06-03 | Brown | Texas | 48049 | 59 | 10 |
208590 | 208590 | 2020-06-04 | Brown | Texas | 48049 | 59 | 10 |
211673 | 211673 | 2020-06-05 | Brown | Texas | 48049 | 59 | 10 |
214760 | 214760 | 2020-06-06 | Brown | Texas | 48049 | 59 | 10 |
217850 | 217850 | 2020-06-07 | Brown | Texas | 48049 | 59 | 10 |
220942 | 220942 | 2020-06-08 | Brown | Texas | 48049 | 59 | 10 |
224037 | 224037 | 2020-06-09 | Brown | Texas | 48049 | 60 | 10 |
227137 | 227137 | 2020-06-10 | Brown | Texas | 48049 | 60 | 10 |
230241 | 230241 | 2020-06-11 | Brown | Texas | 48049 | 60 | 10 |
233345 | 233345 | 2020-06-12 | Brown | Texas | 48049 | 60 | 10 |
236451 | 236451 | 2020-06-13 | Brown | Texas | 48049 | 60 | 10 |
239559 | 239559 | 2020-06-14 | Brown | Texas | 48049 | 60 | 10 |
242669 | 242669 | 2020-06-15 | Brown | Texas | 48049 | 60 | 10 |
245781 | 245781 | 2020-06-16 | Brown | Texas | 48049 | 61 | 10 |
248894 | 248894 | 2020-06-17 | Brown | Texas | 48049 | 61 | 10 |
252009 | 252009 | 2020-06-18 | Brown | Texas | 48049 | 61 | 10 |
255124 | 255124 | 2020-06-19 | Brown | Texas | 48049 | 62 | 10 |
258250 | 258250 | 2020-06-20 | Brown | Texas | 48049 | 62 | 10 |
261377 | 261377 | 2020-06-21 | Brown | Texas | 48049 | 62 | 10 |
264505 | 264505 | 2020-06-22 | Brown | Texas | 48049 | 62 | 10 |
267633 | 267633 | 2020-06-23 | Brown | Texas | 48049 | 65 | 10 |
270767 | 270767 | 2020-06-24 | Brown | Texas | 48049 | 65 | 10 |
273906 | 273906 | 2020-06-25 | Brown | Texas | 48049 | 66 | 10 |
277053 | 277053 | 2020-06-26 | Brown | Texas | 48049 | 68 | 10 |
280201 | 280201 | 2020-06-27 | Brown | Texas | 48049 | 68 | 10 |
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);