ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Faulkner" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382853 | 382853 | 2020-07-30 | Faulkner | Arkansas | 5045 | 1158 | 5 |
379636 | 379636 | 2020-07-29 | Faulkner | Arkansas | 5045 | 1138 | 4 |
376420 | 376420 | 2020-07-28 | Faulkner | Arkansas | 5045 | 1120 | 4 |
373206 | 373206 | 2020-07-27 | Faulkner | Arkansas | 5045 | 1081 | 4 |
369994 | 369994 | 2020-07-26 | Faulkner | Arkansas | 5045 | 1063 | 4 |
366784 | 366784 | 2020-07-25 | Faulkner | Arkansas | 5045 | 1046 | 4 |
363577 | 363577 | 2020-07-24 | Faulkner | Arkansas | 5045 | 1013 | 4 |
360370 | 360370 | 2020-07-23 | Faulkner | Arkansas | 5045 | 996 | 4 |
357165 | 357165 | 2020-07-22 | Faulkner | Arkansas | 5045 | 970 | 4 |
353962 | 353962 | 2020-07-21 | Faulkner | Arkansas | 5045 | 940 | 4 |
350760 | 350760 | 2020-07-20 | Faulkner | Arkansas | 5045 | 926 | 4 |
347559 | 347559 | 2020-07-19 | Faulkner | Arkansas | 5045 | 905 | 4 |
344359 | 344359 | 2020-07-18 | Faulkner | Arkansas | 5045 | 888 | 4 |
341160 | 341160 | 2020-07-17 | Faulkner | Arkansas | 5045 | 869 | 4 |
337964 | 337964 | 2020-07-16 | Faulkner | Arkansas | 5045 | 857 | 4 |
334769 | 334769 | 2020-07-15 | Faulkner | Arkansas | 5045 | 830 | 4 |
331576 | 331576 | 2020-07-14 | Faulkner | Arkansas | 5045 | 810 | 4 |
328390 | 328390 | 2020-07-13 | Faulkner | Arkansas | 5045 | 788 | 3 |
325204 | 325204 | 2020-07-12 | Faulkner | Arkansas | 5045 | 771 | 3 |
322023 | 322023 | 2020-07-11 | Faulkner | Arkansas | 5045 | 757 | 3 |
318844 | 318844 | 2020-07-10 | Faulkner | Arkansas | 5045 | 727 | 3 |
315671 | 315671 | 2020-07-09 | Faulkner | Arkansas | 5045 | 701 | 3 |
312496 | 312496 | 2020-07-08 | Faulkner | Arkansas | 5045 | 648 | 3 |
309326 | 309326 | 2020-07-07 | Faulkner | Arkansas | 5045 | 622 | 3 |
306158 | 306158 | 2020-07-06 | Faulkner | Arkansas | 5045 | 612 | 3 |
302994 | 302994 | 2020-07-05 | Faulkner | Arkansas | 5045 | 593 | 3 |
299830 | 299830 | 2020-07-04 | Faulkner | Arkansas | 5045 | 564 | 3 |
296668 | 296668 | 2020-07-03 | Faulkner | Arkansas | 5045 | 545 | 3 |
293512 | 293512 | 2020-07-02 | Faulkner | Arkansas | 5045 | 529 | 3 |
290358 | 290358 | 2020-07-01 | Faulkner | Arkansas | 5045 | 492 | 3 |
287207 | 287207 | 2020-06-30 | Faulkner | Arkansas | 5045 | 477 | 3 |
284061 | 284061 | 2020-06-29 | Faulkner | Arkansas | 5045 | 453 | 3 |
280915 | 280915 | 2020-06-28 | Faulkner | Arkansas | 5045 | 437 | 3 |
277768 | 277768 | 2020-06-27 | Faulkner | Arkansas | 5045 | 409 | 3 |
274620 | 274620 | 2020-06-26 | Faulkner | Arkansas | 5045 | 382 | 3 |
271480 | 271480 | 2020-06-25 | Faulkner | Arkansas | 5045 | 350 | 3 |
268345 | 268345 | 2020-06-24 | Faulkner | Arkansas | 5045 | 339 | 3 |
265215 | 265215 | 2020-06-23 | Faulkner | Arkansas | 5045 | 305 | 3 |
262087 | 262087 | 2020-06-22 | Faulkner | Arkansas | 5045 | 290 | 3 |
258960 | 258960 | 2020-06-21 | Faulkner | Arkansas | 5045 | 269 | 3 |
255833 | 255833 | 2020-06-20 | Faulkner | Arkansas | 5045 | 246 | 3 |
252714 | 252714 | 2020-06-19 | Faulkner | Arkansas | 5045 | 227 | 3 |
249599 | 249599 | 2020-06-18 | Faulkner | Arkansas | 5045 | 205 | 3 |
246487 | 246487 | 2020-06-17 | Faulkner | Arkansas | 5045 | 195 | 3 |
243374 | 243374 | 2020-06-16 | Faulkner | Arkansas | 5045 | 180 | 3 |
240263 | 240263 | 2020-06-15 | Faulkner | Arkansas | 5045 | 172 | 3 |
237155 | 237155 | 2020-06-14 | Faulkner | Arkansas | 5045 | 154 | 3 |
234048 | 234048 | 2020-06-13 | Faulkner | Arkansas | 5045 | 147 | 3 |
230942 | 230942 | 2020-06-12 | Faulkner | Arkansas | 5045 | 142 | 3 |
227839 | 227839 | 2020-06-11 | Faulkner | Arkansas | 5045 | 136 | 3 |
224737 | 224737 | 2020-06-10 | Faulkner | Arkansas | 5045 | 124 | 3 |
221642 | 221642 | 2020-06-09 | Faulkner | Arkansas | 5045 | 119 | 3 |
218547 | 218547 | 2020-06-08 | Faulkner | Arkansas | 5045 | 117 | 3 |
215456 | 215456 | 2020-06-07 | Faulkner | Arkansas | 5045 | 113 | 3 |
212369 | 212369 | 2020-06-06 | Faulkner | Arkansas | 5045 | 110 | 3 |
209284 | 209284 | 2020-06-05 | Faulkner | Arkansas | 5045 | 108 | 3 |
206203 | 206203 | 2020-06-04 | Faulkner | Arkansas | 5045 | 108 | 3 |
203123 | 203123 | 2020-06-03 | Faulkner | Arkansas | 5045 | 106 | 3 |
200047 | 200047 | 2020-06-02 | Faulkner | Arkansas | 5045 | 103 | 3 |
196974 | 196974 | 2020-06-01 | Faulkner | Arkansas | 5045 | 102 | 3 |
193904 | 193904 | 2020-05-31 | Faulkner | Arkansas | 5045 | 102 | 3 |
190837 | 190837 | 2020-05-30 | Faulkner | Arkansas | 5045 | 102 | 3 |
187772 | 187772 | 2020-05-29 | Faulkner | Arkansas | 5045 | 102 | 3 |
184716 | 184716 | 2020-05-28 | Faulkner | Arkansas | 5045 | 101 | 3 |
181662 | 181662 | 2020-05-27 | Faulkner | Arkansas | 5045 | 100 | 3 |
178618 | 178618 | 2020-05-26 | Faulkner | Arkansas | 5045 | 100 | 3 |
175574 | 175574 | 2020-05-25 | Faulkner | Arkansas | 5045 | 100 | 3 |
172530 | 172530 | 2020-05-24 | Faulkner | Arkansas | 5045 | 100 | 3 |
169489 | 169489 | 2020-05-23 | Faulkner | Arkansas | 5045 | 100 | 3 |
166453 | 166453 | 2020-05-22 | Faulkner | Arkansas | 5045 | 98 | 3 |
163421 | 163421 | 2020-05-21 | Faulkner | Arkansas | 5045 | 98 | 3 |
160393 | 160393 | 2020-05-20 | Faulkner | Arkansas | 5045 | 95 | 3 |
157367 | 157367 | 2020-05-19 | Faulkner | Arkansas | 5045 | 95 | 3 |
154351 | 154351 | 2020-05-18 | Faulkner | Arkansas | 5045 | 94 | 3 |
151339 | 151339 | 2020-05-17 | Faulkner | Arkansas | 5045 | 93 | 3 |
148330 | 148330 | 2020-05-16 | Faulkner | Arkansas | 5045 | 91 | 3 |
145327 | 145327 | 2020-05-15 | Faulkner | Arkansas | 5045 | 88 | 3 |
142328 | 142328 | 2020-05-14 | Faulkner | Arkansas | 5045 | 83 | 3 |
139332 | 139332 | 2020-05-13 | Faulkner | Arkansas | 5045 | 83 | 3 |
136341 | 136341 | 2020-05-12 | Faulkner | Arkansas | 5045 | 82 | 2 |
133351 | 133351 | 2020-05-11 | Faulkner | Arkansas | 5045 | 82 | 2 |
130361 | 130361 | 2020-05-10 | Faulkner | Arkansas | 5045 | 82 | 2 |
127371 | 127371 | 2020-05-09 | Faulkner | Arkansas | 5045 | 81 | 2 |
124386 | 124386 | 2020-05-08 | Faulkner | Arkansas | 5045 | 81 | 2 |
121406 | 121406 | 2020-05-07 | Faulkner | Arkansas | 5045 | 81 | 2 |
118439 | 118439 | 2020-05-06 | Faulkner | Arkansas | 5045 | 78 | 2 |
115480 | 115480 | 2020-05-05 | Faulkner | Arkansas | 5045 | 77 | 2 |
112597 | 112597 | 2020-05-04 | Faulkner | Arkansas | 5045 | 77 | 2 |
109722 | 109722 | 2020-05-03 | Faulkner | Arkansas | 5045 | 77 | 2 |
106853 | 106853 | 2020-05-02 | Faulkner | Arkansas | 5045 | 76 | 2 |
103988 | 103988 | 2020-05-01 | Faulkner | Arkansas | 5045 | 76 | 2 |
101133 | 101133 | 2020-04-30 | Faulkner | Arkansas | 5045 | 76 | 2 |
98283 | 98283 | 2020-04-29 | Faulkner | Arkansas | 5045 | 76 | 2 |
95438 | 95438 | 2020-04-28 | Faulkner | Arkansas | 5045 | 75 | 2 |
92608 | 92608 | 2020-04-27 | Faulkner | Arkansas | 5045 | 75 | 2 |
89790 | 89790 | 2020-04-26 | Faulkner | Arkansas | 5045 | 73 | 2 |
86973 | 86973 | 2020-04-25 | Faulkner | Arkansas | 5045 | 70 | 2 |
84165 | 84165 | 2020-04-24 | Faulkner | Arkansas | 5045 | 67 | 2 |
81365 | 81365 | 2020-04-23 | Faulkner | Arkansas | 5045 | 67 | 2 |
78572 | 78572 | 2020-04-22 | Faulkner | Arkansas | 5045 | 65 | 2 |
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);