ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 22037 and state = "Louisiana" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
12963 | 12963 | 2020-03-26 | East Feliciana | Louisiana | 22037 | 4 | 0 |
14670 | 14670 | 2020-03-27 | East Feliciana | Louisiana | 22037 | 5 | 0 |
16489 | 16489 | 2020-03-28 | East Feliciana | Louisiana | 22037 | 6 | 0 |
18401 | 18401 | 2020-03-29 | East Feliciana | Louisiana | 22037 | 8 | 0 |
20417 | 20417 | 2020-03-30 | East Feliciana | Louisiana | 22037 | 8 | 0 |
22525 | 22525 | 2020-03-31 | East Feliciana | Louisiana | 22037 | 9 | 0 |
24701 | 24701 | 2020-04-01 | East Feliciana | Louisiana | 22037 | 10 | 0 |
26952 | 26952 | 2020-04-02 | East Feliciana | Louisiana | 22037 | 14 | 0 |
29269 | 29269 | 2020-04-03 | East Feliciana | Louisiana | 22037 | 19 | 0 |
31647 | 31647 | 2020-04-04 | East Feliciana | Louisiana | 22037 | 22 | 0 |
34072 | 34072 | 2020-04-05 | East Feliciana | Louisiana | 22037 | 27 | 0 |
36530 | 36530 | 2020-04-06 | East Feliciana | Louisiana | 22037 | 39 | 0 |
39038 | 39038 | 2020-04-07 | East Feliciana | Louisiana | 22037 | 39 | 0 |
41590 | 41590 | 2020-04-08 | East Feliciana | Louisiana | 22037 | 39 | 1 |
44166 | 44166 | 2020-04-09 | East Feliciana | Louisiana | 22037 | 59 | 2 |
46774 | 46774 | 2020-04-10 | East Feliciana | Louisiana | 22037 | 65 | 2 |
49415 | 49415 | 2020-04-11 | East Feliciana | Louisiana | 22037 | 67 | 2 |
52085 | 52085 | 2020-04-12 | East Feliciana | Louisiana | 22037 | 71 | 2 |
54766 | 54766 | 2020-04-13 | East Feliciana | Louisiana | 22037 | 73 | 2 |
57464 | 57464 | 2020-04-14 | East Feliciana | Louisiana | 22037 | 77 | 4 |
60172 | 60172 | 2020-04-15 | East Feliciana | Louisiana | 22037 | 81 | 7 |
62893 | 62893 | 2020-04-16 | East Feliciana | Louisiana | 22037 | 84 | 7 |
65632 | 65632 | 2020-04-17 | East Feliciana | Louisiana | 22037 | 90 | 7 |
68381 | 68381 | 2020-04-18 | East Feliciana | Louisiana | 22037 | 90 | 7 |
71144 | 71144 | 2020-04-19 | East Feliciana | Louisiana | 22037 | 93 | 7 |
73916 | 73916 | 2020-04-20 | East Feliciana | Louisiana | 22037 | 95 | 7 |
76696 | 76696 | 2020-04-21 | East Feliciana | Louisiana | 22037 | 101 | 8 |
79482 | 79482 | 2020-04-22 | East Feliciana | Louisiana | 22037 | 102 | 10 |
82278 | 82278 | 2020-04-23 | East Feliciana | Louisiana | 22037 | 106 | 10 |
85082 | 85082 | 2020-04-24 | East Feliciana | Louisiana | 22037 | 105 | 10 |
87891 | 87891 | 2020-04-25 | East Feliciana | Louisiana | 22037 | 107 | 11 |
90707 | 90707 | 2020-04-26 | East Feliciana | Louisiana | 22037 | 108 | 11 |
93528 | 93528 | 2020-04-27 | East Feliciana | Louisiana | 22037 | 116 | 11 |
96363 | 96363 | 2020-04-28 | East Feliciana | Louisiana | 22037 | 118 | 12 |
99209 | 99209 | 2020-04-29 | East Feliciana | Louisiana | 22037 | 119 | 12 |
102061 | 102061 | 2020-04-30 | East Feliciana | Louisiana | 22037 | 122 | 14 |
104922 | 104922 | 2020-05-01 | East Feliciana | Louisiana | 22037 | 128 | 14 |
107786 | 107786 | 2020-05-02 | East Feliciana | Louisiana | 22037 | 128 | 15 |
110658 | 110658 | 2020-05-03 | East Feliciana | Louisiana | 22037 | 129 | 16 |
113535 | 113535 | 2020-05-04 | East Feliciana | Louisiana | 22037 | 130 | 16 |
116417 | 116417 | 2020-05-05 | East Feliciana | Louisiana | 22037 | 131 | 16 |
119378 | 119378 | 2020-05-06 | East Feliciana | Louisiana | 22037 | 132 | 18 |
122349 | 122349 | 2020-05-07 | East Feliciana | Louisiana | 22037 | 132 | 19 |
125331 | 125331 | 2020-05-08 | East Feliciana | Louisiana | 22037 | 133 | 19 |
128318 | 128318 | 2020-05-09 | East Feliciana | Louisiana | 22037 | 136 | 21 |
131308 | 131308 | 2020-05-10 | East Feliciana | Louisiana | 22037 | 135 | 21 |
134299 | 134299 | 2020-05-11 | East Feliciana | Louisiana | 22037 | 136 | 20 |
137289 | 137289 | 2020-05-12 | East Feliciana | Louisiana | 22037 | 140 | 20 |
140283 | 140283 | 2020-05-13 | East Feliciana | Louisiana | 22037 | 145 | 21 |
143278 | 143278 | 2020-05-14 | East Feliciana | Louisiana | 22037 | 169 | 21 |
146278 | 146278 | 2020-05-15 | East Feliciana | Louisiana | 22037 | 172 | 21 |
149283 | 149283 | 2020-05-16 | East Feliciana | Louisiana | 22037 | 176 | 22 |
152294 | 152294 | 2020-05-17 | East Feliciana | Louisiana | 22037 | 176 | 22 |
155308 | 155308 | 2020-05-18 | East Feliciana | Louisiana | 22037 | 177 | 23 |
158326 | 158326 | 2020-05-19 | East Feliciana | Louisiana | 22037 | 179 | 24 |
161352 | 161352 | 2020-05-20 | East Feliciana | Louisiana | 22037 | 179 | 27 |
164381 | 164381 | 2020-05-21 | East Feliciana | Louisiana | 22037 | 183 | 27 |
167417 | 167417 | 2020-05-22 | East Feliciana | Louisiana | 22037 | 184 | 27 |
170455 | 170455 | 2020-05-23 | East Feliciana | Louisiana | 22037 | 185 | 28 |
173496 | 173496 | 2020-05-24 | East Feliciana | Louisiana | 22037 | 187 | 28 |
176540 | 176540 | 2020-05-25 | East Feliciana | Louisiana | 22037 | 190 | 28 |
179584 | 179584 | 2020-05-26 | East Feliciana | Louisiana | 22037 | 190 | 28 |
182629 | 182629 | 2020-05-27 | East Feliciana | Louisiana | 22037 | 191 | 28 |
185684 | 185684 | 2020-05-28 | East Feliciana | Louisiana | 22037 | 192 | 30 |
188742 | 188742 | 2020-05-29 | East Feliciana | Louisiana | 22037 | 192 | 30 |
191806 | 191806 | 2020-05-30 | East Feliciana | Louisiana | 22037 | 194 | 30 |
194874 | 194874 | 2020-05-31 | East Feliciana | Louisiana | 22037 | 194 | 30 |
197945 | 197945 | 2020-06-01 | East Feliciana | Louisiana | 22037 | 197 | 30 |
201017 | 201017 | 2020-06-02 | East Feliciana | Louisiana | 22037 | 198 | 30 |
204094 | 204094 | 2020-06-03 | East Feliciana | Louisiana | 22037 | 198 | 30 |
207175 | 207175 | 2020-06-04 | East Feliciana | Louisiana | 22037 | 199 | 30 |
210256 | 210256 | 2020-06-05 | East Feliciana | Louisiana | 22037 | 199 | 30 |
213341 | 213341 | 2020-06-06 | East Feliciana | Louisiana | 22037 | 201 | 30 |
216428 | 216428 | 2020-06-07 | East Feliciana | Louisiana | 22037 | 201 | 30 |
219520 | 219520 | 2020-06-08 | East Feliciana | Louisiana | 22037 | 201 | 30 |
222615 | 222615 | 2020-06-09 | East Feliciana | Louisiana | 22037 | 207 | 31 |
225711 | 225711 | 2020-06-10 | East Feliciana | Louisiana | 22037 | 210 | 31 |
228813 | 228813 | 2020-06-11 | East Feliciana | Louisiana | 22037 | 210 | 31 |
231917 | 231917 | 2020-06-12 | East Feliciana | Louisiana | 22037 | 216 | 32 |
235022 | 235022 | 2020-06-13 | East Feliciana | Louisiana | 22037 | 225 | 32 |
238129 | 238129 | 2020-06-14 | East Feliciana | Louisiana | 22037 | 226 | 32 |
241238 | 241238 | 2020-06-15 | East Feliciana | Louisiana | 22037 | 227 | 32 |
244349 | 244349 | 2020-06-16 | East Feliciana | Louisiana | 22037 | 229 | 32 |
247462 | 247462 | 2020-06-17 | East Feliciana | Louisiana | 22037 | 231 | 32 |
250574 | 250574 | 2020-06-18 | East Feliciana | Louisiana | 22037 | 231 | 32 |
253689 | 253689 | 2020-06-19 | East Feliciana | Louisiana | 22037 | 263 | 32 |
256809 | 256809 | 2020-06-20 | East Feliciana | Louisiana | 22037 | 268 | 32 |
259935 | 259935 | 2020-06-21 | East Feliciana | Louisiana | 22037 | 268 | 32 |
263064 | 263064 | 2020-06-22 | East Feliciana | Louisiana | 22037 | 271 | 32 |
266191 | 266191 | 2020-06-23 | East Feliciana | Louisiana | 22037 | 273 | 33 |
269324 | 269324 | 2020-06-24 | East Feliciana | Louisiana | 22037 | 276 | 33 |
272460 | 272460 | 2020-06-25 | East Feliciana | Louisiana | 22037 | 285 | 33 |
275603 | 275603 | 2020-06-26 | East Feliciana | Louisiana | 22037 | 288 | 33 |
278751 | 278751 | 2020-06-27 | East Feliciana | Louisiana | 22037 | 288 | 33 |
281899 | 281899 | 2020-06-28 | East Feliciana | Louisiana | 22037 | 298 | 33 |
285045 | 285045 | 2020-06-29 | East Feliciana | Louisiana | 22037 | 299 | 33 |
288194 | 288194 | 2020-06-30 | East Feliciana | Louisiana | 22037 | 297 | 33 |
291345 | 291345 | 2020-07-01 | East Feliciana | Louisiana | 22037 | 300 | 33 |
294499 | 294499 | 2020-07-02 | East Feliciana | Louisiana | 22037 | 302 | 33 |
297657 | 297657 | 2020-07-03 | East Feliciana | Louisiana | 22037 | 308 | 33 |
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);