ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22073 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387089 | 387089 | 2020-07-31 | Ouachita | Louisiana | 22073 | 4372 | 105 |
383871 | 383871 | 2020-07-30 | Ouachita | Louisiana | 22073 | 4304 | 104 |
380654 | 380654 | 2020-07-29 | Ouachita | Louisiana | 22073 | 4246 | 103 |
377437 | 377437 | 2020-07-28 | Ouachita | Louisiana | 22073 | 4169 | 100 |
374222 | 374222 | 2020-07-27 | Ouachita | Louisiana | 22073 | 4144 | 99 |
371010 | 371010 | 2020-07-26 | Ouachita | Louisiana | 22073 | 4102 | 99 |
367800 | 367800 | 2020-07-25 | Ouachita | Louisiana | 22073 | 3916 | 97 |
364593 | 364593 | 2020-07-24 | Ouachita | Louisiana | 22073 | 3916 | 97 |
361386 | 361386 | 2020-07-23 | Ouachita | Louisiana | 22073 | 3845 | 97 |
358181 | 358181 | 2020-07-22 | Ouachita | Louisiana | 22073 | 3778 | 98 |
354978 | 354978 | 2020-07-21 | Ouachita | Louisiana | 22073 | 3669 | 98 |
351776 | 351776 | 2020-07-20 | Ouachita | Louisiana | 22073 | 3643 | 95 |
348576 | 348576 | 2020-07-19 | Ouachita | Louisiana | 22073 | 3569 | 96 |
345375 | 345375 | 2020-07-18 | Ouachita | Louisiana | 22073 | 3475 | 95 |
342175 | 342175 | 2020-07-17 | Ouachita | Louisiana | 22073 | 3475 | 95 |
338979 | 338979 | 2020-07-16 | Ouachita | Louisiana | 22073 | 3388 | 95 |
335783 | 335783 | 2020-07-15 | Ouachita | Louisiana | 22073 | 3296 | 92 |
332590 | 332590 | 2020-07-14 | Ouachita | Louisiana | 22073 | 3214 | 90 |
329403 | 329403 | 2020-07-13 | Ouachita | Louisiana | 22073 | 3175 | 86 |
326217 | 326217 | 2020-07-12 | Ouachita | Louisiana | 22073 | 3120 | 86 |
323034 | 323034 | 2020-07-11 | Ouachita | Louisiana | 22073 | 3079 | 86 |
319855 | 319855 | 2020-07-10 | Ouachita | Louisiana | 22073 | 2988 | 85 |
316680 | 316680 | 2020-07-09 | Ouachita | Louisiana | 22073 | 2849 | 84 |
313506 | 313506 | 2020-07-08 | Ouachita | Louisiana | 22073 | 2794 | 82 |
310336 | 310336 | 2020-07-07 | Ouachita | Louisiana | 22073 | 2730 | 80 |
307168 | 307168 | 2020-07-06 | Ouachita | Louisiana | 22073 | 2694 | 80 |
304001 | 304001 | 2020-07-05 | Ouachita | Louisiana | 22073 | 2667 | 80 |
300837 | 300837 | 2020-07-04 | Ouachita | Louisiana | 22073 | 2591 | 80 |
297675 | 297675 | 2020-07-03 | Ouachita | Louisiana | 22073 | 2591 | 80 |
294517 | 294517 | 2020-07-02 | Ouachita | Louisiana | 22073 | 2537 | 78 |
291363 | 291363 | 2020-07-01 | Ouachita | Louisiana | 22073 | 2474 | 75 |
288212 | 288212 | 2020-06-30 | Ouachita | Louisiana | 22073 | 2392 | 74 |
285063 | 285063 | 2020-06-29 | Ouachita | Louisiana | 22073 | 2331 | 73 |
281917 | 281917 | 2020-06-28 | Ouachita | Louisiana | 22073 | 2267 | 73 |
278769 | 278769 | 2020-06-27 | Ouachita | Louisiana | 22073 | 2199 | 72 |
275621 | 275621 | 2020-06-26 | Ouachita | Louisiana | 22073 | 2199 | 72 |
272478 | 272478 | 2020-06-25 | Ouachita | Louisiana | 22073 | 2125 | 72 |
269342 | 269342 | 2020-06-24 | Ouachita | Louisiana | 22073 | 2066 | 71 |
266209 | 266209 | 2020-06-23 | Ouachita | Louisiana | 22073 | 2022 | 69 |
263082 | 263082 | 2020-06-22 | Ouachita | Louisiana | 22073 | 1980 | 67 |
259953 | 259953 | 2020-06-21 | Ouachita | Louisiana | 22073 | 1960 | 66 |
256827 | 256827 | 2020-06-20 | Ouachita | Louisiana | 22073 | 1927 | 66 |
253707 | 253707 | 2020-06-19 | Ouachita | Louisiana | 22073 | 1881 | 66 |
250592 | 250592 | 2020-06-18 | Ouachita | Louisiana | 22073 | 1889 | 66 |
247480 | 247480 | 2020-06-17 | Ouachita | Louisiana | 22073 | 1889 | 66 |
244367 | 244367 | 2020-06-16 | Ouachita | Louisiana | 22073 | 1832 | 61 |
241256 | 241256 | 2020-06-15 | Ouachita | Louisiana | 22073 | 1813 | 59 |
238147 | 238147 | 2020-06-14 | Ouachita | Louisiana | 22073 | 1782 | 59 |
235040 | 235040 | 2020-06-13 | Ouachita | Louisiana | 22073 | 1744 | 59 |
231935 | 231935 | 2020-06-12 | Ouachita | Louisiana | 22073 | 1679 | 59 |
228831 | 228831 | 2020-06-11 | Ouachita | Louisiana | 22073 | 1631 | 57 |
225729 | 225729 | 2020-06-10 | Ouachita | Louisiana | 22073 | 1592 | 57 |
222633 | 222633 | 2020-06-09 | Ouachita | Louisiana | 22073 | 1543 | 56 |
219538 | 219538 | 2020-06-08 | Ouachita | Louisiana | 22073 | 1500 | 54 |
216446 | 216446 | 2020-06-07 | Ouachita | Louisiana | 22073 | 1470 | 54 |
213359 | 213359 | 2020-06-06 | Ouachita | Louisiana | 22073 | 1432 | 53 |
210274 | 210274 | 2020-06-05 | Ouachita | Louisiana | 22073 | 1396 | 51 |
207193 | 207193 | 2020-06-04 | Ouachita | Louisiana | 22073 | 1346 | 49 |
204112 | 204112 | 2020-06-03 | Ouachita | Louisiana | 22073 | 1312 | 48 |
201035 | 201035 | 2020-06-02 | Ouachita | Louisiana | 22073 | 1289 | 44 |
197963 | 197963 | 2020-06-01 | Ouachita | Louisiana | 22073 | 1264 | 41 |
194892 | 194892 | 2020-05-31 | Ouachita | Louisiana | 22073 | 1248 | 41 |
191824 | 191824 | 2020-05-30 | Ouachita | Louisiana | 22073 | 1219 | 41 |
188760 | 188760 | 2020-05-29 | Ouachita | Louisiana | 22073 | 1166 | 41 |
185702 | 185702 | 2020-05-28 | Ouachita | Louisiana | 22073 | 1166 | 40 |
182647 | 182647 | 2020-05-27 | Ouachita | Louisiana | 22073 | 1150 | 37 |
179602 | 179602 | 2020-05-26 | Ouachita | Louisiana | 22073 | 1125 | 37 |
176558 | 176558 | 2020-05-25 | Ouachita | Louisiana | 22073 | 1102 | 35 |
173514 | 173514 | 2020-05-24 | Ouachita | Louisiana | 22073 | 1045 | 35 |
170473 | 170473 | 2020-05-23 | Ouachita | Louisiana | 22073 | 1042 | 35 |
167435 | 167435 | 2020-05-22 | Ouachita | Louisiana | 22073 | 1041 | 35 |
164399 | 164399 | 2020-05-21 | Ouachita | Louisiana | 22073 | 1032 | 34 |
161370 | 161370 | 2020-05-20 | Ouachita | Louisiana | 22073 | 980 | 34 |
158344 | 158344 | 2020-05-19 | Ouachita | Louisiana | 22073 | 966 | 32 |
155326 | 155326 | 2020-05-18 | Ouachita | Louisiana | 22073 | 956 | 31 |
152312 | 152312 | 2020-05-17 | Ouachita | Louisiana | 22073 | 946 | 31 |
149301 | 149301 | 2020-05-16 | Ouachita | Louisiana | 22073 | 931 | 31 |
146296 | 146296 | 2020-05-15 | Ouachita | Louisiana | 22073 | 891 | 31 |
143296 | 143296 | 2020-05-14 | Ouachita | Louisiana | 22073 | 869 | 31 |
140301 | 140301 | 2020-05-13 | Ouachita | Louisiana | 22073 | 861 | 31 |
137307 | 137307 | 2020-05-12 | Ouachita | Louisiana | 22073 | 856 | 27 |
134317 | 134317 | 2020-05-11 | Ouachita | Louisiana | 22073 | 842 | 25 |
131326 | 131326 | 2020-05-10 | Ouachita | Louisiana | 22073 | 842 | 25 |
128336 | 128336 | 2020-05-09 | Ouachita | Louisiana | 22073 | 836 | 25 |
125349 | 125349 | 2020-05-08 | Ouachita | Louisiana | 22073 | 820 | 25 |
122367 | 122367 | 2020-05-07 | Ouachita | Louisiana | 22073 | 814 | 25 |
119396 | 119396 | 2020-05-06 | Ouachita | Louisiana | 22073 | 806 | 24 |
116435 | 116435 | 2020-05-05 | Ouachita | Louisiana | 22073 | 793 | 22 |
113553 | 113553 | 2020-05-04 | Ouachita | Louisiana | 22073 | 785 | 22 |
110676 | 110676 | 2020-05-03 | Ouachita | Louisiana | 22073 | 770 | 22 |
107804 | 107804 | 2020-05-02 | Ouachita | Louisiana | 22073 | 755 | 22 |
104940 | 104940 | 2020-05-01 | Ouachita | Louisiana | 22073 | 730 | 21 |
102079 | 102079 | 2020-04-30 | Ouachita | Louisiana | 22073 | 706 | 16 |
99227 | 99227 | 2020-04-29 | Ouachita | Louisiana | 22073 | 671 | 16 |
96381 | 96381 | 2020-04-28 | Ouachita | Louisiana | 22073 | 651 | 16 |
93546 | 93546 | 2020-04-27 | Ouachita | Louisiana | 22073 | 645 | 16 |
90725 | 90725 | 2020-04-26 | Ouachita | Louisiana | 22073 | 622 | 16 |
87909 | 87909 | 2020-04-25 | Ouachita | Louisiana | 22073 | 609 | 16 |
85100 | 85100 | 2020-04-24 | Ouachita | Louisiana | 22073 | 598 | 16 |
82296 | 82296 | 2020-04-23 | Ouachita | Louisiana | 22073 | 579 | 16 |
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);