ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Concordia", deaths = 5 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
278747 | 278747 | 2020-06-27 | Concordia | Louisiana | 22029 | 106 | 5 |
275599 | 275599 | 2020-06-26 | Concordia | Louisiana | 22029 | 106 | 5 |
272456 | 272456 | 2020-06-25 | Concordia | Louisiana | 22029 | 105 | 5 |
269320 | 269320 | 2020-06-24 | Concordia | Louisiana | 22029 | 105 | 5 |
266187 | 266187 | 2020-06-23 | Concordia | Louisiana | 22029 | 105 | 5 |
263060 | 263060 | 2020-06-22 | Concordia | Louisiana | 22029 | 102 | 5 |
259931 | 259931 | 2020-06-21 | Concordia | Louisiana | 22029 | 101 | 5 |
256805 | 256805 | 2020-06-20 | Concordia | Louisiana | 22029 | 101 | 5 |
253685 | 253685 | 2020-06-19 | Concordia | Louisiana | 22029 | 100 | 5 |
250570 | 250570 | 2020-06-18 | Concordia | Louisiana | 22029 | 117 | 5 |
247458 | 247458 | 2020-06-17 | Concordia | Louisiana | 22029 | 117 | 5 |
244345 | 244345 | 2020-06-16 | Concordia | Louisiana | 22029 | 109 | 5 |
241234 | 241234 | 2020-06-15 | Concordia | Louisiana | 22029 | 107 | 5 |
238125 | 238125 | 2020-06-14 | Concordia | Louisiana | 22029 | 105 | 5 |
235018 | 235018 | 2020-06-13 | Concordia | Louisiana | 22029 | 105 | 5 |
231913 | 231913 | 2020-06-12 | Concordia | Louisiana | 22029 | 97 | 5 |
228809 | 228809 | 2020-06-11 | Concordia | Louisiana | 22029 | 97 | 5 |
225707 | 225707 | 2020-06-10 | Concordia | Louisiana | 22029 | 97 | 5 |
222611 | 222611 | 2020-06-09 | Concordia | Louisiana | 22029 | 97 | 5 |
219516 | 219516 | 2020-06-08 | Concordia | Louisiana | 22029 | 96 | 5 |
216424 | 216424 | 2020-06-07 | Concordia | Louisiana | 22029 | 96 | 5 |
213337 | 213337 | 2020-06-06 | Concordia | Louisiana | 22029 | 96 | 5 |
210252 | 210252 | 2020-06-05 | Concordia | Louisiana | 22029 | 95 | 5 |
207171 | 207171 | 2020-06-04 | Concordia | Louisiana | 22029 | 94 | 5 |
204090 | 204090 | 2020-06-03 | Concordia | Louisiana | 22029 | 94 | 5 |
201013 | 201013 | 2020-06-02 | Concordia | Louisiana | 22029 | 88 | 5 |
197941 | 197941 | 2020-06-01 | Concordia | Louisiana | 22029 | 88 | 5 |
194870 | 194870 | 2020-05-31 | Concordia | Louisiana | 22029 | 87 | 5 |
191802 | 191802 | 2020-05-30 | Concordia | Louisiana | 22029 | 87 | 5 |
188738 | 188738 | 2020-05-29 | Concordia | Louisiana | 22029 | 86 | 5 |
185680 | 185680 | 2020-05-28 | Concordia | Louisiana | 22029 | 86 | 5 |
182625 | 182625 | 2020-05-27 | Concordia | Louisiana | 22029 | 86 | 5 |
179580 | 179580 | 2020-05-26 | Concordia | Louisiana | 22029 | 74 | 5 |
176536 | 176536 | 2020-05-25 | Concordia | Louisiana | 22029 | 73 | 5 |
173492 | 173492 | 2020-05-24 | Concordia | Louisiana | 22029 | 69 | 5 |
170451 | 170451 | 2020-05-23 | Concordia | Louisiana | 22029 | 69 | 5 |
167413 | 167413 | 2020-05-22 | Concordia | Louisiana | 22029 | 69 | 5 |
164377 | 164377 | 2020-05-21 | Concordia | Louisiana | 22029 | 68 | 5 |
161348 | 161348 | 2020-05-20 | Concordia | Louisiana | 22029 | 57 | 5 |
158322 | 158322 | 2020-05-19 | Concordia | Louisiana | 22029 | 57 | 5 |
155304 | 155304 | 2020-05-18 | Concordia | Louisiana | 22029 | 57 | 5 |
152290 | 152290 | 2020-05-17 | Concordia | Louisiana | 22029 | 57 | 5 |
113531 | 113531 | 2020-05-04 | Concordia | Louisiana | 22029 | 40 | 5 |
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);