ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Bossier" and state = "Louisiana" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2074 | 2074 | 2020-03-14 | Bossier | Louisiana | 22015 | 1 | 0 |
2471 | 2471 | 2020-03-15 | Bossier | Louisiana | 22015 | 1 | 0 |
2917 | 2917 | 2020-03-16 | Bossier | Louisiana | 22015 | 1 | 0 |
3413 | 3413 | 2020-03-17 | Bossier | Louisiana | 22015 | 1 | 0 |
3993 | 3993 | 2020-03-18 | Bossier | Louisiana | 22015 | 2 | 0 |
4685 | 4685 | 2020-03-19 | Bossier | Louisiana | 22015 | 4 | 0 |
5499 | 5499 | 2020-03-20 | Bossier | Louisiana | 22015 | 5 | 0 |
6450 | 6450 | 2020-03-21 | Bossier | Louisiana | 22015 | 5 | 0 |
7525 | 7525 | 2020-03-22 | Bossier | Louisiana | 22015 | 5 | 0 |
8689 | 8689 | 2020-03-23 | Bossier | Louisiana | 22015 | 12 | 0 |
9977 | 9977 | 2020-03-24 | Bossier | Louisiana | 22015 | 12 | 0 |
11381 | 11381 | 2020-03-25 | Bossier | Louisiana | 22015 | 25 | 0 |
12956 | 12956 | 2020-03-26 | Bossier | Louisiana | 22015 | 32 | 0 |
14663 | 14663 | 2020-03-27 | Bossier | Louisiana | 22015 | 37 | 0 |
16481 | 16481 | 2020-03-28 | Bossier | Louisiana | 22015 | 45 | 0 |
18393 | 18393 | 2020-03-29 | Bossier | Louisiana | 22015 | 56 | 0 |
20409 | 20409 | 2020-03-30 | Bossier | Louisiana | 22015 | 57 | 0 |
22516 | 22516 | 2020-03-31 | Bossier | Louisiana | 22015 | 63 | 1 |
24692 | 24692 | 2020-04-01 | Bossier | Louisiana | 22015 | 75 | 1 |
26942 | 26942 | 2020-04-02 | Bossier | Louisiana | 22015 | 87 | 2 |
29259 | 29259 | 2020-04-03 | Bossier | Louisiana | 22015 | 95 | 2 |
31637 | 31637 | 2020-04-04 | Bossier | Louisiana | 22015 | 126 | 2 |
34062 | 34062 | 2020-04-05 | Bossier | Louisiana | 22015 | 133 | 3 |
36520 | 36520 | 2020-04-06 | Bossier | Louisiana | 22015 | 139 | 3 |
39027 | 39027 | 2020-04-07 | Bossier | Louisiana | 22015 | 146 | 4 |
41579 | 41579 | 2020-04-08 | Bossier | Louisiana | 22015 | 159 | 6 |
44155 | 44155 | 2020-04-09 | Bossier | Louisiana | 22015 | 171 | 7 |
46763 | 46763 | 2020-04-10 | Bossier | Louisiana | 22015 | 175 | 7 |
49404 | 49404 | 2020-04-11 | Bossier | Louisiana | 22015 | 178 | 9 |
52074 | 52074 | 2020-04-12 | Bossier | Louisiana | 22015 | 186 | 9 |
54755 | 54755 | 2020-04-13 | Bossier | Louisiana | 22015 | 188 | 10 |
57453 | 57453 | 2020-04-14 | Bossier | Louisiana | 22015 | 207 | 10 |
60161 | 60161 | 2020-04-15 | Bossier | Louisiana | 22015 | 211 | 11 |
62882 | 62882 | 2020-04-16 | Bossier | Louisiana | 22015 | 220 | 11 |
65621 | 65621 | 2020-04-17 | Bossier | Louisiana | 22015 | 230 | 11 |
68370 | 68370 | 2020-04-18 | Bossier | Louisiana | 22015 | 230 | 11 |
71133 | 71133 | 2020-04-19 | Bossier | Louisiana | 22015 | 233 | 11 |
73905 | 73905 | 2020-04-20 | Bossier | Louisiana | 22015 | 233 | 11 |
76685 | 76685 | 2020-04-21 | Bossier | Louisiana | 22015 | 241 | 11 |
79471 | 79471 | 2020-04-22 | Bossier | Louisiana | 22015 | 246 | 12 |
82267 | 82267 | 2020-04-23 | Bossier | Louisiana | 22015 | 255 | 12 |
85071 | 85071 | 2020-04-24 | Bossier | Louisiana | 22015 | 258 | 12 |
87880 | 87880 | 2020-04-25 | Bossier | Louisiana | 22015 | 265 | 12 |
90696 | 90696 | 2020-04-26 | Bossier | Louisiana | 22015 | 270 | 13 |
93517 | 93517 | 2020-04-27 | Bossier | Louisiana | 22015 | 274 | 13 |
96352 | 96352 | 2020-04-28 | Bossier | Louisiana | 22015 | 277 | 14 |
99198 | 99198 | 2020-04-29 | Bossier | Louisiana | 22015 | 285 | 15 |
102050 | 102050 | 2020-04-30 | Bossier | Louisiana | 22015 | 286 | 17 |
104911 | 104911 | 2020-05-01 | Bossier | Louisiana | 22015 | 287 | 17 |
107775 | 107775 | 2020-05-02 | Bossier | Louisiana | 22015 | 292 | 17 |
110647 | 110647 | 2020-05-03 | Bossier | Louisiana | 22015 | 295 | 17 |
113524 | 113524 | 2020-05-04 | Bossier | Louisiana | 22015 | 300 | 17 |
116406 | 116406 | 2020-05-05 | Bossier | Louisiana | 22015 | 300 | 17 |
119367 | 119367 | 2020-05-06 | Bossier | Louisiana | 22015 | 303 | 18 |
122338 | 122338 | 2020-05-07 | Bossier | Louisiana | 22015 | 307 | 18 |
125320 | 125320 | 2020-05-08 | Bossier | Louisiana | 22015 | 308 | 19 |
128307 | 128307 | 2020-05-09 | Bossier | Louisiana | 22015 | 310 | 20 |
131297 | 131297 | 2020-05-10 | Bossier | Louisiana | 22015 | 310 | 20 |
134288 | 134288 | 2020-05-11 | Bossier | Louisiana | 22015 | 312 | 21 |
137278 | 137278 | 2020-05-12 | Bossier | Louisiana | 22015 | 313 | 22 |
140272 | 140272 | 2020-05-13 | Bossier | Louisiana | 22015 | 324 | 22 |
143267 | 143267 | 2020-05-14 | Bossier | Louisiana | 22015 | 327 | 22 |
146267 | 146267 | 2020-05-15 | Bossier | Louisiana | 22015 | 336 | 23 |
149272 | 149272 | 2020-05-16 | Bossier | Louisiana | 22015 | 342 | 23 |
152283 | 152283 | 2020-05-17 | Bossier | Louisiana | 22015 | 344 | 23 |
155297 | 155297 | 2020-05-18 | Bossier | Louisiana | 22015 | 346 | 24 |
158315 | 158315 | 2020-05-19 | Bossier | Louisiana | 22015 | 348 | 24 |
161341 | 161341 | 2020-05-20 | Bossier | Louisiana | 22015 | 353 | 24 |
164370 | 164370 | 2020-05-21 | Bossier | Louisiana | 22015 | 374 | 24 |
167406 | 167406 | 2020-05-22 | Bossier | Louisiana | 22015 | 380 | 25 |
170444 | 170444 | 2020-05-23 | Bossier | Louisiana | 22015 | 381 | 25 |
173485 | 173485 | 2020-05-24 | Bossier | Louisiana | 22015 | 382 | 25 |
176529 | 176529 | 2020-05-25 | Bossier | Louisiana | 22015 | 398 | 25 |
179573 | 179573 | 2020-05-26 | Bossier | Louisiana | 22015 | 398 | 25 |
182618 | 182618 | 2020-05-27 | Bossier | Louisiana | 22015 | 402 | 25 |
185673 | 185673 | 2020-05-28 | Bossier | Louisiana | 22015 | 406 | 25 |
188731 | 188731 | 2020-05-29 | Bossier | Louisiana | 22015 | 406 | 26 |
191795 | 191795 | 2020-05-30 | Bossier | Louisiana | 22015 | 412 | 26 |
194863 | 194863 | 2020-05-31 | Bossier | Louisiana | 22015 | 415 | 26 |
197934 | 197934 | 2020-06-01 | Bossier | Louisiana | 22015 | 416 | 26 |
201006 | 201006 | 2020-06-02 | Bossier | Louisiana | 22015 | 421 | 26 |
204083 | 204083 | 2020-06-03 | Bossier | Louisiana | 22015 | 425 | 25 |
207164 | 207164 | 2020-06-04 | Bossier | Louisiana | 22015 | 438 | 25 |
210245 | 210245 | 2020-06-05 | Bossier | Louisiana | 22015 | 450 | 25 |
213330 | 213330 | 2020-06-06 | Bossier | Louisiana | 22015 | 453 | 25 |
216417 | 216417 | 2020-06-07 | Bossier | Louisiana | 22015 | 463 | 26 |
219509 | 219509 | 2020-06-08 | Bossier | Louisiana | 22015 | 464 | 26 |
222604 | 222604 | 2020-06-09 | Bossier | Louisiana | 22015 | 473 | 26 |
225700 | 225700 | 2020-06-10 | Bossier | Louisiana | 22015 | 478 | 26 |
228802 | 228802 | 2020-06-11 | Bossier | Louisiana | 22015 | 484 | 26 |
231906 | 231906 | 2020-06-12 | Bossier | Louisiana | 22015 | 488 | 26 |
235011 | 235011 | 2020-06-13 | Bossier | Louisiana | 22015 | 494 | 27 |
238118 | 238118 | 2020-06-14 | Bossier | Louisiana | 22015 | 502 | 28 |
241227 | 241227 | 2020-06-15 | Bossier | Louisiana | 22015 | 510 | 28 |
244338 | 244338 | 2020-06-16 | Bossier | Louisiana | 22015 | 513 | 28 |
247451 | 247451 | 2020-06-17 | Bossier | Louisiana | 22015 | 528 | 28 |
250563 | 250563 | 2020-06-18 | Bossier | Louisiana | 22015 | 528 | 28 |
253678 | 253678 | 2020-06-19 | Bossier | Louisiana | 22015 | 643 | 28 |
256798 | 256798 | 2020-06-20 | Bossier | Louisiana | 22015 | 654 | 28 |
259924 | 259924 | 2020-06-21 | Bossier | Louisiana | 22015 | 665 | 28 |
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);