ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,534 rows where county = "Red River" 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 |
---|---|---|---|---|---|---|---|
18423 | 18423 | 2020-03-29 | Red River | Louisiana | 22081 | 1 | 0 |
20439 | 20439 | 2020-03-30 | Red River | Louisiana | 22081 | 1 | 0 |
22547 | 22547 | 2020-03-31 | Red River | Louisiana | 22081 | 1 | 0 |
24723 | 24723 | 2020-04-01 | Red River | Louisiana | 22081 | 1 | 0 |
26974 | 26974 | 2020-04-02 | Red River | Louisiana | 22081 | 1 | 0 |
29291 | 29291 | 2020-04-03 | Red River | Louisiana | 22081 | 2 | 0 |
31669 | 31669 | 2020-04-04 | Red River | Louisiana | 22081 | 2 | 0 |
34094 | 34094 | 2020-04-05 | Red River | Louisiana | 22081 | 2 | 0 |
36552 | 36552 | 2020-04-06 | Red River | Louisiana | 22081 | 2 | 0 |
39060 | 39060 | 2020-04-07 | Red River | Louisiana | 22081 | 2 | 1 |
41612 | 41612 | 2020-04-08 | Red River | Louisiana | 22081 | 3 | 1 |
44188 | 44188 | 2020-04-09 | Red River | Louisiana | 22081 | 5 | 1 |
46796 | 46796 | 2020-04-10 | Red River | Louisiana | 22081 | 7 | 1 |
49437 | 49437 | 2020-04-11 | Red River | Louisiana | 22081 | 9 | 1 |
52107 | 52107 | 2020-04-12 | Red River | Louisiana | 22081 | 11 | 2 |
54788 | 54788 | 2020-04-13 | Red River | Louisiana | 22081 | 12 | 2 |
57486 | 57486 | 2020-04-14 | Red River | Louisiana | 22081 | 13 | 2 |
60194 | 60194 | 2020-04-15 | Red River | Louisiana | 22081 | 13 | 2 |
62915 | 62915 | 2020-04-16 | Red River | Louisiana | 22081 | 15 | 3 |
65654 | 65654 | 2020-04-17 | Red River | Louisiana | 22081 | 18 | 3 |
68403 | 68403 | 2020-04-18 | Red River | Louisiana | 22081 | 19 | 3 |
71166 | 71166 | 2020-04-19 | Red River | Louisiana | 22081 | 20 | 3 |
73938 | 73938 | 2020-04-20 | Red River | Louisiana | 22081 | 21 | 4 |
76718 | 76718 | 2020-04-21 | Red River | Louisiana | 22081 | 21 | 4 |
79504 | 79504 | 2020-04-22 | Red River | Louisiana | 22081 | 22 | 4 |
82300 | 82300 | 2020-04-23 | Red River | Louisiana | 22081 | 22 | 4 |
85104 | 85104 | 2020-04-24 | Red River | Louisiana | 22081 | 22 | 4 |
87913 | 87913 | 2020-04-25 | Red River | Louisiana | 22081 | 22 | 4 |
90729 | 90729 | 2020-04-26 | Red River | Louisiana | 22081 | 22 | 4 |
93550 | 93550 | 2020-04-27 | Red River | Louisiana | 22081 | 22 | 5 |
96385 | 96385 | 2020-04-28 | Red River | Louisiana | 22081 | 23 | 5 |
99231 | 99231 | 2020-04-29 | Red River | Louisiana | 22081 | 24 | 5 |
102083 | 102083 | 2020-04-30 | Red River | Louisiana | 22081 | 25 | 5 |
104944 | 104944 | 2020-05-01 | Red River | Louisiana | 22081 | 29 | 5 |
107808 | 107808 | 2020-05-02 | Red River | Louisiana | 22081 | 32 | 5 |
110680 | 110680 | 2020-05-03 | Red River | Louisiana | 22081 | 32 | 5 |
113557 | 113557 | 2020-05-04 | Red River | Louisiana | 22081 | 33 | 5 |
116439 | 116439 | 2020-05-05 | Red River | Louisiana | 22081 | 34 | 6 |
119400 | 119400 | 2020-05-06 | Red River | Louisiana | 22081 | 34 | 6 |
122371 | 122371 | 2020-05-07 | Red River | Louisiana | 22081 | 34 | 6 |
125353 | 125353 | 2020-05-08 | Red River | Louisiana | 22081 | 34 | 6 |
128340 | 128340 | 2020-05-09 | Red River | Louisiana | 22081 | 36 | 6 |
131330 | 131330 | 2020-05-10 | Red River | Louisiana | 22081 | 36 | 6 |
134321 | 134321 | 2020-05-11 | Red River | Louisiana | 22081 | 36 | 6 |
137311 | 137311 | 2020-05-12 | Red River | Louisiana | 22081 | 36 | 6 |
140305 | 140305 | 2020-05-13 | Red River | Louisiana | 22081 | 37 | 6 |
143300 | 143300 | 2020-05-14 | Red River | Louisiana | 22081 | 38 | 6 |
146300 | 146300 | 2020-05-15 | Red River | Louisiana | 22081 | 40 | 6 |
149305 | 149305 | 2020-05-16 | Red River | Louisiana | 22081 | 42 | 6 |
152316 | 152316 | 2020-05-17 | Red River | Louisiana | 22081 | 42 | 6 |
155330 | 155330 | 2020-05-18 | Red River | Louisiana | 22081 | 43 | 6 |
158348 | 158348 | 2020-05-19 | Red River | Louisiana | 22081 | 43 | 6 |
161374 | 161374 | 2020-05-20 | Red River | Louisiana | 22081 | 43 | 6 |
164403 | 164403 | 2020-05-21 | Red River | Louisiana | 22081 | 44 | 6 |
167439 | 167439 | 2020-05-22 | Red River | Louisiana | 22081 | 46 | 6 |
170477 | 170477 | 2020-05-23 | Red River | Louisiana | 22081 | 46 | 6 |
173518 | 173518 | 2020-05-24 | Red River | Louisiana | 22081 | 47 | 6 |
176562 | 176562 | 2020-05-25 | Red River | Louisiana | 22081 | 48 | 6 |
179606 | 179606 | 2020-05-26 | Red River | Louisiana | 22081 | 48 | 6 |
182651 | 182651 | 2020-05-27 | Red River | Louisiana | 22081 | 48 | 6 |
185706 | 185706 | 2020-05-28 | Red River | Louisiana | 22081 | 49 | 7 |
188764 | 188764 | 2020-05-29 | Red River | Louisiana | 22081 | 49 | 7 |
191828 | 191828 | 2020-05-30 | Red River | Louisiana | 22081 | 50 | 7 |
194896 | 194896 | 2020-05-31 | Red River | Louisiana | 22081 | 50 | 7 |
197967 | 197967 | 2020-06-01 | Red River | Louisiana | 22081 | 50 | 7 |
201039 | 201039 | 2020-06-02 | Red River | Louisiana | 22081 | 50 | 7 |
204116 | 204116 | 2020-06-03 | Red River | Louisiana | 22081 | 50 | 7 |
207197 | 207197 | 2020-06-04 | Red River | Louisiana | 22081 | 51 | 7 |
210278 | 210278 | 2020-06-05 | Red River | Louisiana | 22081 | 51 | 7 |
213363 | 213363 | 2020-06-06 | Red River | Louisiana | 22081 | 51 | 7 |
216450 | 216450 | 2020-06-07 | Red River | Louisiana | 22081 | 51 | 7 |
219542 | 219542 | 2020-06-08 | Red River | Louisiana | 22081 | 51 | 7 |
222637 | 222637 | 2020-06-09 | Red River | Louisiana | 22081 | 52 | 7 |
225733 | 225733 | 2020-06-10 | Red River | Louisiana | 22081 | 52 | 7 |
228835 | 228835 | 2020-06-11 | Red River | Louisiana | 22081 | 52 | 7 |
231939 | 231939 | 2020-06-12 | Red River | Louisiana | 22081 | 52 | 7 |
235044 | 235044 | 2020-06-13 | Red River | Louisiana | 22081 | 52 | 7 |
238151 | 238151 | 2020-06-14 | Red River | Louisiana | 22081 | 52 | 7 |
241260 | 241260 | 2020-06-15 | Red River | Louisiana | 22081 | 53 | 7 |
244371 | 244371 | 2020-06-16 | Red River | Louisiana | 22081 | 52 | 8 |
247484 | 247484 | 2020-06-17 | Red River | Louisiana | 22081 | 52 | 8 |
250596 | 250596 | 2020-06-18 | Red River | Louisiana | 22081 | 52 | 8 |
253711 | 253711 | 2020-06-19 | Red River | Louisiana | 22081 | 54 | 8 |
256831 | 256831 | 2020-06-20 | Red River | Louisiana | 22081 | 54 | 8 |
259957 | 259957 | 2020-06-21 | Red River | Louisiana | 22081 | 54 | 8 |
263086 | 263086 | 2020-06-22 | Red River | Louisiana | 22081 | 54 | 8 |
266213 | 266213 | 2020-06-23 | Red River | Louisiana | 22081 | 53 | 8 |
269346 | 269346 | 2020-06-24 | Red River | Louisiana | 22081 | 54 | 8 |
272482 | 272482 | 2020-06-25 | Red River | Louisiana | 22081 | 54 | 8 |
275625 | 275625 | 2020-06-26 | Red River | Louisiana | 22081 | 56 | 8 |
278773 | 278773 | 2020-06-27 | Red River | Louisiana | 22081 | 56 | 8 |
281921 | 281921 | 2020-06-28 | Red River | Louisiana | 22081 | 60 | 8 |
285067 | 285067 | 2020-06-29 | Red River | Louisiana | 22081 | 60 | 8 |
288216 | 288216 | 2020-06-30 | Red River | Louisiana | 22081 | 60 | 8 |
291367 | 291367 | 2020-07-01 | Red River | Louisiana | 22081 | 62 | 8 |
294521 | 294521 | 2020-07-02 | Red River | Louisiana | 22081 | 62 | 8 |
297679 | 297679 | 2020-07-03 | Red River | Louisiana | 22081 | 62 | 8 |
300841 | 300841 | 2020-07-04 | Red River | Louisiana | 22081 | 62 | 8 |
304005 | 304005 | 2020-07-05 | Red River | Louisiana | 22081 | 64 | 8 |
307172 | 307172 | 2020-07-06 | Red River | Louisiana | 22081 | 64 | 8 |
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);