ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "St. Helena" and state = "Louisiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22552 | 22552 | 2020-03-31 | St. Helena | Louisiana | 22091 | 1 | 0 |
24728 | 24728 | 2020-04-01 | St. Helena | Louisiana | 22091 | 1 | 0 |
26979 | 26979 | 2020-04-02 | St. Helena | Louisiana | 22091 | 1 | 0 |
29296 | 29296 | 2020-04-03 | St. Helena | Louisiana | 22091 | 1 | 0 |
31674 | 31674 | 2020-04-04 | St. Helena | Louisiana | 22091 | 4 | 0 |
34099 | 34099 | 2020-04-05 | St. Helena | Louisiana | 22091 | 5 | 0 |
36557 | 36557 | 2020-04-06 | St. Helena | Louisiana | 22091 | 8 | 0 |
39065 | 39065 | 2020-04-07 | St. Helena | Louisiana | 22091 | 10 | 0 |
41617 | 41617 | 2020-04-08 | St. Helena | Louisiana | 22091 | 10 | 0 |
44193 | 44193 | 2020-04-09 | St. Helena | Louisiana | 22091 | 11 | 0 |
46801 | 46801 | 2020-04-10 | St. Helena | Louisiana | 22091 | 11 | 0 |
49442 | 49442 | 2020-04-11 | St. Helena | Louisiana | 22091 | 13 | 0 |
52112 | 52112 | 2020-04-12 | St. Helena | Louisiana | 22091 | 13 | 0 |
54793 | 54793 | 2020-04-13 | St. Helena | Louisiana | 22091 | 14 | 0 |
57491 | 57491 | 2020-04-14 | St. Helena | Louisiana | 22091 | 14 | 0 |
60199 | 60199 | 2020-04-15 | St. Helena | Louisiana | 22091 | 14 | 0 |
62920 | 62920 | 2020-04-16 | St. Helena | Louisiana | 22091 | 17 | 1 |
65659 | 65659 | 2020-04-17 | St. Helena | Louisiana | 22091 | 18 | 1 |
68408 | 68408 | 2020-04-18 | St. Helena | Louisiana | 22091 | 19 | 1 |
71171 | 71171 | 2020-04-19 | St. Helena | Louisiana | 22091 | 19 | 1 |
73943 | 73943 | 2020-04-20 | St. Helena | Louisiana | 22091 | 20 | 1 |
76723 | 76723 | 2020-04-21 | St. Helena | Louisiana | 22091 | 21 | 1 |
79509 | 79509 | 2020-04-22 | St. Helena | Louisiana | 22091 | 22 | 1 |
82305 | 82305 | 2020-04-23 | St. Helena | Louisiana | 22091 | 23 | 1 |
85109 | 85109 | 2020-04-24 | St. Helena | Louisiana | 22091 | 23 | 1 |
87918 | 87918 | 2020-04-25 | St. Helena | Louisiana | 22091 | 27 | 1 |
90734 | 90734 | 2020-04-26 | St. Helena | Louisiana | 22091 | 27 | 1 |
93555 | 93555 | 2020-04-27 | St. Helena | Louisiana | 22091 | 27 | 1 |
96390 | 96390 | 2020-04-28 | St. Helena | Louisiana | 22091 | 28 | 1 |
99236 | 99236 | 2020-04-29 | St. Helena | Louisiana | 22091 | 28 | 1 |
102088 | 102088 | 2020-04-30 | St. Helena | Louisiana | 22091 | 28 | 1 |
104949 | 104949 | 2020-05-01 | St. Helena | Louisiana | 22091 | 28 | 1 |
107813 | 107813 | 2020-05-02 | St. Helena | Louisiana | 22091 | 30 | 1 |
110685 | 110685 | 2020-05-03 | St. Helena | Louisiana | 22091 | 30 | 1 |
113562 | 113562 | 2020-05-04 | St. Helena | Louisiana | 22091 | 31 | 1 |
116444 | 116444 | 2020-05-05 | St. Helena | Louisiana | 22091 | 32 | 1 |
119405 | 119405 | 2020-05-06 | St. Helena | Louisiana | 22091 | 32 | 1 |
122376 | 122376 | 2020-05-07 | St. Helena | Louisiana | 22091 | 32 | 1 |
125358 | 125358 | 2020-05-08 | St. Helena | Louisiana | 22091 | 32 | 1 |
128345 | 128345 | 2020-05-09 | St. Helena | Louisiana | 22091 | 35 | 1 |
131335 | 131335 | 2020-05-10 | St. Helena | Louisiana | 22091 | 35 | 1 |
134326 | 134326 | 2020-05-11 | St. Helena | Louisiana | 22091 | 35 | 1 |
137316 | 137316 | 2020-05-12 | St. Helena | Louisiana | 22091 | 38 | 1 |
140310 | 140310 | 2020-05-13 | St. Helena | Louisiana | 22091 | 38 | 1 |
143305 | 143305 | 2020-05-14 | St. Helena | Louisiana | 22091 | 38 | 1 |
146305 | 146305 | 2020-05-15 | St. Helena | Louisiana | 22091 | 40 | 1 |
149310 | 149310 | 2020-05-16 | St. Helena | Louisiana | 22091 | 41 | 1 |
152321 | 152321 | 2020-05-17 | St. Helena | Louisiana | 22091 | 41 | 1 |
155335 | 155335 | 2020-05-18 | St. Helena | Louisiana | 22091 | 41 | 1 |
158353 | 158353 | 2020-05-19 | St. Helena | Louisiana | 22091 | 41 | 1 |
161379 | 161379 | 2020-05-20 | St. Helena | Louisiana | 22091 | 42 | 1 |
164408 | 164408 | 2020-05-21 | St. Helena | Louisiana | 22091 | 43 | 1 |
167444 | 167444 | 2020-05-22 | St. Helena | Louisiana | 22091 | 44 | 1 |
170482 | 170482 | 2020-05-23 | St. Helena | Louisiana | 22091 | 44 | 1 |
173523 | 173523 | 2020-05-24 | St. Helena | Louisiana | 22091 | 44 | 1 |
176567 | 176567 | 2020-05-25 | St. Helena | Louisiana | 22091 | 49 | 1 |
179611 | 179611 | 2020-05-26 | St. Helena | Louisiana | 22091 | 51 | 1 |
182656 | 182656 | 2020-05-27 | St. Helena | Louisiana | 22091 | 51 | 1 |
185711 | 185711 | 2020-05-28 | St. Helena | Louisiana | 22091 | 51 | 1 |
188769 | 188769 | 2020-05-29 | St. Helena | Louisiana | 22091 | 51 | 1 |
191833 | 191833 | 2020-05-30 | St. Helena | Louisiana | 22091 | 51 | 1 |
194901 | 194901 | 2020-05-31 | St. Helena | Louisiana | 22091 | 51 | 1 |
197972 | 197972 | 2020-06-01 | St. Helena | Louisiana | 22091 | 51 | 1 |
201044 | 201044 | 2020-06-02 | St. Helena | Louisiana | 22091 | 51 | 1 |
204121 | 204121 | 2020-06-03 | St. Helena | Louisiana | 22091 | 51 | 1 |
207202 | 207202 | 2020-06-04 | St. Helena | Louisiana | 22091 | 52 | 1 |
210283 | 210283 | 2020-06-05 | St. Helena | Louisiana | 22091 | 53 | 1 |
213368 | 213368 | 2020-06-06 | St. Helena | Louisiana | 22091 | 55 | 1 |
216455 | 216455 | 2020-06-07 | St. Helena | Louisiana | 22091 | 55 | 1 |
219547 | 219547 | 2020-06-08 | St. Helena | Louisiana | 22091 | 55 | 1 |
222642 | 222642 | 2020-06-09 | St. Helena | Louisiana | 22091 | 55 | 1 |
225738 | 225738 | 2020-06-10 | St. Helena | Louisiana | 22091 | 56 | 1 |
228840 | 228840 | 2020-06-11 | St. Helena | Louisiana | 22091 | 56 | 1 |
231944 | 231944 | 2020-06-12 | St. Helena | Louisiana | 22091 | 56 | 1 |
235049 | 235049 | 2020-06-13 | St. Helena | Louisiana | 22091 | 58 | 1 |
238156 | 238156 | 2020-06-14 | St. Helena | Louisiana | 22091 | 58 | 1 |
241265 | 241265 | 2020-06-15 | St. Helena | Louisiana | 22091 | 58 | 1 |
244376 | 244376 | 2020-06-16 | St. Helena | Louisiana | 22091 | 60 | 1 |
247489 | 247489 | 2020-06-17 | St. Helena | Louisiana | 22091 | 60 | 1 |
250601 | 250601 | 2020-06-18 | St. Helena | Louisiana | 22091 | 60 | 1 |
253716 | 253716 | 2020-06-19 | St. Helena | Louisiana | 22091 | 85 | 1 |
256836 | 256836 | 2020-06-20 | St. Helena | Louisiana | 22091 | 86 | 1 |
259962 | 259962 | 2020-06-21 | St. Helena | Louisiana | 22091 | 86 | 1 |
263091 | 263091 | 2020-06-22 | St. Helena | Louisiana | 22091 | 86 | 1 |
266218 | 266218 | 2020-06-23 | St. Helena | Louisiana | 22091 | 88 | 1 |
269351 | 269351 | 2020-06-24 | St. Helena | Louisiana | 22091 | 88 | 1 |
272487 | 272487 | 2020-06-25 | St. Helena | Louisiana | 22091 | 88 | 1 |
275630 | 275630 | 2020-06-26 | St. Helena | Louisiana | 22091 | 89 | 1 |
278778 | 278778 | 2020-06-27 | St. Helena | Louisiana | 22091 | 89 | 1 |
281926 | 281926 | 2020-06-28 | St. Helena | Louisiana | 22091 | 89 | 1 |
285072 | 285072 | 2020-06-29 | St. Helena | Louisiana | 22091 | 90 | 1 |
288221 | 288221 | 2020-06-30 | St. Helena | Louisiana | 22091 | 97 | 1 |
291372 | 291372 | 2020-07-01 | St. Helena | Louisiana | 22091 | 99 | 1 |
294526 | 294526 | 2020-07-02 | St. Helena | Louisiana | 22091 | 103 | 1 |
297684 | 297684 | 2020-07-03 | St. Helena | Louisiana | 22091 | 103 | 1 |
300846 | 300846 | 2020-07-04 | St. Helena | Louisiana | 22091 | 103 | 1 |
304010 | 304010 | 2020-07-05 | St. Helena | Louisiana | 22091 | 103 | 1 |
307177 | 307177 | 2020-07-06 | St. Helena | Louisiana | 22091 | 104 | 1 |
310345 | 310345 | 2020-07-07 | St. Helena | Louisiana | 22091 | 113 | 1 |
313515 | 313515 | 2020-07-08 | St. Helena | Louisiana | 22091 | 114 | 1 |
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);