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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, 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 |
64232 | 64232 | 2020-04-16 | Red River | Texas | 48387 | 1 | 0 |
65654 | 65654 | 2020-04-17 | Red River | Louisiana | 22081 | 18 | 3 |
66979 | 66979 | 2020-04-17 | Red River | Texas | 48387 | 1 | 0 |
68403 | 68403 | 2020-04-18 | Red River | Louisiana | 22081 | 19 | 3 |
69739 | 69739 | 2020-04-18 | Red River | Texas | 48387 | 1 | 0 |
71166 | 71166 | 2020-04-19 | Red River | Louisiana | 22081 | 20 | 3 |
72509 | 72509 | 2020-04-19 | Red River | Texas | 48387 | 1 | 0 |
73938 | 73938 | 2020-04-20 | Red River | Louisiana | 22081 | 21 | 4 |
75285 | 75285 | 2020-04-20 | Red River | Texas | 48387 | 1 | 0 |
76718 | 76718 | 2020-04-21 | Red River | Louisiana | 22081 | 21 | 4 |
78067 | 78067 | 2020-04-21 | Red River | Texas | 48387 | 1 | 0 |
79504 | 79504 | 2020-04-22 | Red River | Louisiana | 22081 | 22 | 4 |
80858 | 80858 | 2020-04-22 | Red River | Texas | 48387 | 1 | 0 |
82300 | 82300 | 2020-04-23 | Red River | Louisiana | 22081 | 22 | 4 |
83659 | 83659 | 2020-04-23 | Red River | Texas | 48387 | 1 | 0 |
85104 | 85104 | 2020-04-24 | Red River | Louisiana | 22081 | 22 | 4 |
86466 | 86466 | 2020-04-24 | Red River | Texas | 48387 | 1 | 0 |
87913 | 87913 | 2020-04-25 | Red River | Louisiana | 22081 | 22 | 4 |
89281 | 89281 | 2020-04-25 | Red River | Texas | 48387 | 1 | 0 |
90729 | 90729 | 2020-04-26 | Red River | Louisiana | 22081 | 22 | 4 |
92098 | 92098 | 2020-04-26 | Red River | Texas | 48387 | 1 | 0 |
93550 | 93550 | 2020-04-27 | Red River | Louisiana | 22081 | 22 | 5 |
94927 | 94927 | 2020-04-27 | Red River | Texas | 48387 | 1 | 0 |
96385 | 96385 | 2020-04-28 | Red River | Louisiana | 22081 | 23 | 5 |
97768 | 97768 | 2020-04-28 | Red River | Texas | 48387 | 1 | 0 |
99231 | 99231 | 2020-04-29 | Red River | Louisiana | 22081 | 24 | 5 |
100618 | 100618 | 2020-04-29 | Red River | Texas | 48387 | 1 | 0 |
102083 | 102083 | 2020-04-30 | Red River | Louisiana | 22081 | 25 | 5 |
103473 | 103473 | 2020-04-30 | Red River | Texas | 48387 | 1 | 0 |
104944 | 104944 | 2020-05-01 | Red River | Louisiana | 22081 | 29 | 5 |
106337 | 106337 | 2020-05-01 | Red River | Texas | 48387 | 1 | 0 |
107808 | 107808 | 2020-05-02 | Red River | Louisiana | 22081 | 32 | 5 |
109206 | 109206 | 2020-05-02 | Red River | Texas | 48387 | 1 | 0 |
110680 | 110680 | 2020-05-03 | Red River | Louisiana | 22081 | 32 | 5 |
112080 | 112080 | 2020-05-03 | Red River | Texas | 48387 | 1 | 0 |
113557 | 113557 | 2020-05-04 | Red River | Louisiana | 22081 | 33 | 5 |
114962 | 114962 | 2020-05-04 | Red River | Texas | 48387 | 1 | 0 |
116439 | 116439 | 2020-05-05 | Red River | Louisiana | 22081 | 34 | 6 |
117921 | 117921 | 2020-05-05 | Red River | Texas | 48387 | 1 | 0 |
119400 | 119400 | 2020-05-06 | Red River | Louisiana | 22081 | 34 | 6 |
120885 | 120885 | 2020-05-06 | Red River | Texas | 48387 | 1 | 0 |
122371 | 122371 | 2020-05-07 | Red River | Louisiana | 22081 | 34 | 6 |
123864 | 123864 | 2020-05-07 | Red River | Texas | 48387 | 2 | 0 |
125353 | 125353 | 2020-05-08 | Red River | Louisiana | 22081 | 34 | 6 |
126848 | 126848 | 2020-05-08 | Red River | Texas | 48387 | 3 | 0 |
128340 | 128340 | 2020-05-09 | Red River | Louisiana | 22081 | 36 | 6 |
129837 | 129837 | 2020-05-09 | Red River | Texas | 48387 | 3 | 0 |
131330 | 131330 | 2020-05-10 | Red River | Louisiana | 22081 | 36 | 6 |
132827 | 132827 | 2020-05-10 | Red River | Texas | 48387 | 9 | 0 |
134321 | 134321 | 2020-05-11 | Red River | Louisiana | 22081 | 36 | 6 |
135818 | 135818 | 2020-05-11 | Red River | Texas | 48387 | 9 | 0 |
137311 | 137311 | 2020-05-12 | Red River | Louisiana | 22081 | 36 | 6 |
138808 | 138808 | 2020-05-12 | Red River | Texas | 48387 | 27 | 0 |
140305 | 140305 | 2020-05-13 | Red River | Louisiana | 22081 | 37 | 6 |
141804 | 141804 | 2020-05-13 | Red River | Texas | 48387 | 28 | 0 |
143300 | 143300 | 2020-05-14 | Red River | Louisiana | 22081 | 38 | 6 |
144801 | 144801 | 2020-05-14 | Red River | Texas | 48387 | 33 | 0 |
146300 | 146300 | 2020-05-15 | Red River | Louisiana | 22081 | 40 | 6 |
147805 | 147805 | 2020-05-15 | Red River | Texas | 48387 | 35 | 0 |
149305 | 149305 | 2020-05-16 | Red River | Louisiana | 22081 | 42 | 6 |
150813 | 150813 | 2020-05-16 | Red River | Texas | 48387 | 35 | 0 |
152316 | 152316 | 2020-05-17 | Red River | Louisiana | 22081 | 42 | 6 |
153824 | 153824 | 2020-05-17 | Red River | Texas | 48387 | 35 | 0 |
155330 | 155330 | 2020-05-18 | Red River | Louisiana | 22081 | 43 | 6 |
156841 | 156841 | 2020-05-18 | Red River | Texas | 48387 | 35 | 0 |
158348 | 158348 | 2020-05-19 | Red River | Louisiana | 22081 | 43 | 6 |
159864 | 159864 | 2020-05-19 | Red River | Texas | 48387 | 36 | 0 |
161374 | 161374 | 2020-05-20 | Red River | Louisiana | 22081 | 43 | 6 |
162892 | 162892 | 2020-05-20 | Red River | Texas | 48387 | 40 | 4 |
164403 | 164403 | 2020-05-21 | Red River | Louisiana | 22081 | 44 | 6 |
165921 | 165921 | 2020-05-21 | Red River | Texas | 48387 | 42 | 4 |
167439 | 167439 | 2020-05-22 | Red River | Louisiana | 22081 | 46 | 6 |
168957 | 168957 | 2020-05-22 | Red River | Texas | 48387 | 42 | 4 |
170477 | 170477 | 2020-05-23 | Red River | Louisiana | 22081 | 46 | 6 |
171997 | 171997 | 2020-05-23 | Red River | Texas | 48387 | 46 | 4 |
173518 | 173518 | 2020-05-24 | Red River | Louisiana | 22081 | 47 | 6 |
175040 | 175040 | 2020-05-24 | Red River | Texas | 48387 | 46 | 4 |
176562 | 176562 | 2020-05-25 | Red River | Louisiana | 22081 | 48 | 6 |
178085 | 178085 | 2020-05-25 | Red River | Texas | 48387 | 47 | 4 |
179606 | 179606 | 2020-05-26 | Red River | Louisiana | 22081 | 48 | 6 |
181129 | 181129 | 2020-05-26 | Red River | Texas | 48387 | 48 | 4 |
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);