ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Beauregard" and state = "Louisiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
6448 | 6448 | 2020-03-21 | Beauregard | Louisiana | 22011 | 1 | 0 |
7523 | 7523 | 2020-03-22 | Beauregard | Louisiana | 22011 | 1 | 0 |
8687 | 8687 | 2020-03-23 | Beauregard | Louisiana | 22011 | 1 | 0 |
9975 | 9975 | 2020-03-24 | Beauregard | Louisiana | 22011 | 2 | 0 |
11379 | 11379 | 2020-03-25 | Beauregard | Louisiana | 22011 | 3 | 0 |
12954 | 12954 | 2020-03-26 | Beauregard | Louisiana | 22011 | 3 | 0 |
14661 | 14661 | 2020-03-27 | Beauregard | Louisiana | 22011 | 4 | 0 |
16479 | 16479 | 2020-03-28 | Beauregard | Louisiana | 22011 | 4 | 0 |
18391 | 18391 | 2020-03-29 | Beauregard | Louisiana | 22011 | 4 | 0 |
20407 | 20407 | 2020-03-30 | Beauregard | Louisiana | 22011 | 5 | 0 |
22514 | 22514 | 2020-03-31 | Beauregard | Louisiana | 22011 | 5 | 0 |
24690 | 24690 | 2020-04-01 | Beauregard | Louisiana | 22011 | 8 | 0 |
26940 | 26940 | 2020-04-02 | Beauregard | Louisiana | 22011 | 10 | 0 |
29257 | 29257 | 2020-04-03 | Beauregard | Louisiana | 22011 | 13 | 0 |
31635 | 31635 | 2020-04-04 | Beauregard | Louisiana | 22011 | 15 | 0 |
34060 | 34060 | 2020-04-05 | Beauregard | Louisiana | 22011 | 19 | 0 |
36518 | 36518 | 2020-04-06 | Beauregard | Louisiana | 22011 | 23 | 0 |
39025 | 39025 | 2020-04-07 | Beauregard | Louisiana | 22011 | 23 | 0 |
41577 | 41577 | 2020-04-08 | Beauregard | Louisiana | 22011 | 23 | 1 |
44153 | 44153 | 2020-04-09 | Beauregard | Louisiana | 22011 | 26 | 1 |
46761 | 46761 | 2020-04-10 | Beauregard | Louisiana | 22011 | 27 | 1 |
49402 | 49402 | 2020-04-11 | Beauregard | Louisiana | 22011 | 27 | 1 |
52072 | 52072 | 2020-04-12 | Beauregard | Louisiana | 22011 | 27 | 1 |
54753 | 54753 | 2020-04-13 | Beauregard | Louisiana | 22011 | 28 | 1 |
57451 | 57451 | 2020-04-14 | Beauregard | Louisiana | 22011 | 28 | 1 |
60159 | 60159 | 2020-04-15 | Beauregard | Louisiana | 22011 | 30 | 1 |
62880 | 62880 | 2020-04-16 | Beauregard | Louisiana | 22011 | 33 | 2 |
65619 | 65619 | 2020-04-17 | Beauregard | Louisiana | 22011 | 35 | 2 |
68368 | 68368 | 2020-04-18 | Beauregard | Louisiana | 22011 | 35 | 2 |
71131 | 71131 | 2020-04-19 | Beauregard | Louisiana | 22011 | 35 | 2 |
82265 | 82265 | 2020-04-23 | Beauregard | Louisiana | 22011 | 35 | 2 |
85069 | 85069 | 2020-04-24 | Beauregard | Louisiana | 22011 | 35 | 2 |
87878 | 87878 | 2020-04-25 | Beauregard | Louisiana | 22011 | 35 | 3 |
90694 | 90694 | 2020-04-26 | Beauregard | Louisiana | 22011 | 35 | 3 |
73903 | 73903 | 2020-04-20 | Beauregard | Louisiana | 22011 | 36 | 2 |
76683 | 76683 | 2020-04-21 | Beauregard | Louisiana | 22011 | 36 | 2 |
79469 | 79469 | 2020-04-22 | Beauregard | Louisiana | 22011 | 36 | 2 |
93515 | 93515 | 2020-04-27 | Beauregard | Louisiana | 22011 | 36 | 3 |
96350 | 96350 | 2020-04-28 | Beauregard | Louisiana | 22011 | 37 | 3 |
99196 | 99196 | 2020-04-29 | Beauregard | Louisiana | 22011 | 37 | 3 |
102048 | 102048 | 2020-04-30 | Beauregard | Louisiana | 22011 | 39 | 3 |
104909 | 104909 | 2020-05-01 | Beauregard | Louisiana | 22011 | 42 | 3 |
107773 | 107773 | 2020-05-02 | Beauregard | Louisiana | 22011 | 42 | 3 |
110645 | 110645 | 2020-05-03 | Beauregard | Louisiana | 22011 | 43 | 3 |
113522 | 113522 | 2020-05-04 | Beauregard | Louisiana | 22011 | 43 | 3 |
116404 | 116404 | 2020-05-05 | Beauregard | Louisiana | 22011 | 43 | 3 |
119365 | 119365 | 2020-05-06 | Beauregard | Louisiana | 22011 | 44 | 4 |
122336 | 122336 | 2020-05-07 | Beauregard | Louisiana | 22011 | 44 | 4 |
125318 | 125318 | 2020-05-08 | Beauregard | Louisiana | 22011 | 44 | 4 |
128305 | 128305 | 2020-05-09 | Beauregard | Louisiana | 22011 | 46 | 4 |
131295 | 131295 | 2020-05-10 | Beauregard | Louisiana | 22011 | 46 | 4 |
134286 | 134286 | 2020-05-11 | Beauregard | Louisiana | 22011 | 46 | 4 |
137276 | 137276 | 2020-05-12 | Beauregard | Louisiana | 22011 | 46 | 4 |
140270 | 140270 | 2020-05-13 | Beauregard | Louisiana | 22011 | 48 | 4 |
143265 | 143265 | 2020-05-14 | Beauregard | Louisiana | 22011 | 49 | 4 |
146265 | 146265 | 2020-05-15 | Beauregard | Louisiana | 22011 | 50 | 4 |
149270 | 149270 | 2020-05-16 | Beauregard | Louisiana | 22011 | 51 | 4 |
152281 | 152281 | 2020-05-17 | Beauregard | Louisiana | 22011 | 52 | 4 |
155295 | 155295 | 2020-05-18 | Beauregard | Louisiana | 22011 | 52 | 4 |
158313 | 158313 | 2020-05-19 | Beauregard | Louisiana | 22011 | 52 | 4 |
161339 | 161339 | 2020-05-20 | Beauregard | Louisiana | 22011 | 52 | 4 |
164368 | 164368 | 2020-05-21 | Beauregard | Louisiana | 22011 | 54 | 4 |
167404 | 167404 | 2020-05-22 | Beauregard | Louisiana | 22011 | 56 | 4 |
170442 | 170442 | 2020-05-23 | Beauregard | Louisiana | 22011 | 56 | 4 |
173483 | 173483 | 2020-05-24 | Beauregard | Louisiana | 22011 | 56 | 4 |
176527 | 176527 | 2020-05-25 | Beauregard | Louisiana | 22011 | 58 | 4 |
179571 | 179571 | 2020-05-26 | Beauregard | Louisiana | 22011 | 58 | 4 |
182616 | 182616 | 2020-05-27 | Beauregard | Louisiana | 22011 | 61 | 4 |
185671 | 185671 | 2020-05-28 | Beauregard | Louisiana | 22011 | 61 | 4 |
188729 | 188729 | 2020-05-29 | Beauregard | Louisiana | 22011 | 61 | 4 |
191793 | 191793 | 2020-05-30 | Beauregard | Louisiana | 22011 | 66 | 4 |
194861 | 194861 | 2020-05-31 | Beauregard | Louisiana | 22011 | 66 | 4 |
197932 | 197932 | 2020-06-01 | Beauregard | Louisiana | 22011 | 69 | 4 |
201004 | 201004 | 2020-06-02 | Beauregard | Louisiana | 22011 | 69 | 4 |
204081 | 204081 | 2020-06-03 | Beauregard | Louisiana | 22011 | 81 | 4 |
207162 | 207162 | 2020-06-04 | Beauregard | Louisiana | 22011 | 90 | 4 |
210243 | 210243 | 2020-06-05 | Beauregard | Louisiana | 22011 | 99 | 4 |
216415 | 216415 | 2020-06-07 | Beauregard | Louisiana | 22011 | 101 | 4 |
213328 | 213328 | 2020-06-06 | Beauregard | Louisiana | 22011 | 102 | 4 |
219507 | 219507 | 2020-06-08 | Beauregard | Louisiana | 22011 | 106 | 4 |
222602 | 222602 | 2020-06-09 | Beauregard | Louisiana | 22011 | 114 | 4 |
225698 | 225698 | 2020-06-10 | Beauregard | Louisiana | 22011 | 116 | 5 |
228800 | 228800 | 2020-06-11 | Beauregard | Louisiana | 22011 | 117 | 6 |
231904 | 231904 | 2020-06-12 | Beauregard | Louisiana | 22011 | 127 | 6 |
235009 | 235009 | 2020-06-13 | Beauregard | Louisiana | 22011 | 134 | 6 |
238116 | 238116 | 2020-06-14 | Beauregard | Louisiana | 22011 | 134 | 6 |
241225 | 241225 | 2020-06-15 | Beauregard | Louisiana | 22011 | 136 | 6 |
244336 | 244336 | 2020-06-16 | Beauregard | Louisiana | 22011 | 136 | 6 |
247449 | 247449 | 2020-06-17 | Beauregard | Louisiana | 22011 | 139 | 6 |
250561 | 250561 | 2020-06-18 | Beauregard | Louisiana | 22011 | 139 | 6 |
253676 | 253676 | 2020-06-19 | Beauregard | Louisiana | 22011 | 147 | 7 |
256796 | 256796 | 2020-06-20 | Beauregard | Louisiana | 22011 | 155 | 7 |
259922 | 259922 | 2020-06-21 | Beauregard | Louisiana | 22011 | 158 | 7 |
263051 | 263051 | 2020-06-22 | Beauregard | Louisiana | 22011 | 159 | 7 |
266178 | 266178 | 2020-06-23 | Beauregard | Louisiana | 22011 | 165 | 7 |
269311 | 269311 | 2020-06-24 | Beauregard | Louisiana | 22011 | 168 | 8 |
272447 | 272447 | 2020-06-25 | Beauregard | Louisiana | 22011 | 173 | 8 |
275590 | 275590 | 2020-06-26 | Beauregard | Louisiana | 22011 | 184 | 8 |
278738 | 278738 | 2020-06-27 | Beauregard | Louisiana | 22011 | 184 | 8 |
281886 | 281886 | 2020-06-28 | Beauregard | Louisiana | 22011 | 191 | 8 |
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);