ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,212 rows where county = "Adams" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Indiana 795
- Nebraska 787
- Pennsylvania 787
- Illinois 785
- Mississippi 785
- Washington 782
- Idaho 774
- Wisconsin 772
- Ohio 770
- Iowa 727
- Colorado 693
- North Dakota 655
fips 12
county 1
- Adams · 9,112 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
255944 | 255944 | 2020-06-20 | Adams | Colorado | 8001 | 3872 | 152 |
259071 | 259071 | 2020-06-21 | Adams | Colorado | 8001 | 3909 | 152 |
262198 | 262198 | 2020-06-22 | Adams | Colorado | 8001 | 3932 | 153 |
265326 | 265326 | 2020-06-23 | Adams | Colorado | 8001 | 3941 | 154 |
268456 | 268456 | 2020-06-24 | Adams | Colorado | 8001 | 3971 | 154 |
271591 | 271591 | 2020-06-25 | Adams | Colorado | 8001 | 4013 | 154 |
274731 | 274731 | 2020-06-26 | Adams | Colorado | 8001 | 4058 | 154 |
277879 | 277879 | 2020-06-27 | Adams | Colorado | 8001 | 4093 | 154 |
281026 | 281026 | 2020-06-28 | Adams | Colorado | 8001 | 4148 | 154 |
284172 | 284172 | 2020-06-29 | Adams | Colorado | 8001 | 4170 | 155 |
287318 | 287318 | 2020-06-30 | Adams | Colorado | 8001 | 4185 | 155 |
290469 | 290469 | 2020-07-01 | Adams | Colorado | 8001 | 4226 | 156 |
293623 | 293623 | 2020-07-02 | Adams | Colorado | 8001 | 4267 | 156 |
296779 | 296779 | 2020-07-03 | Adams | Colorado | 8001 | 4293 | 156 |
299941 | 299941 | 2020-07-04 | Adams | Colorado | 8001 | 4322 | 156 |
303105 | 303105 | 2020-07-05 | Adams | Colorado | 8001 | 4362 | 156 |
306269 | 306269 | 2020-07-06 | Adams | Colorado | 8001 | 4400 | 156 |
309437 | 309437 | 2020-07-07 | Adams | Colorado | 8001 | 4478 | 156 |
312607 | 312607 | 2020-07-08 | Adams | Colorado | 8001 | 4546 | 156 |
315782 | 315782 | 2020-07-09 | Adams | Colorado | 8001 | 4588 | 156 |
318955 | 318955 | 2020-07-10 | Adams | Colorado | 8001 | 4669 | 157 |
322134 | 322134 | 2020-07-11 | Adams | Colorado | 8001 | 4719 | 158 |
325315 | 325315 | 2020-07-12 | Adams | Colorado | 8001 | 4757 | 158 |
328501 | 328501 | 2020-07-13 | Adams | Colorado | 8001 | 4788 | 158 |
331687 | 331687 | 2020-07-14 | Adams | Colorado | 8001 | 4847 | 159 |
334880 | 334880 | 2020-07-15 | Adams | Colorado | 8001 | 4916 | 159 |
338075 | 338075 | 2020-07-16 | Adams | Colorado | 8001 | 4972 | 159 |
341271 | 341271 | 2020-07-17 | Adams | Colorado | 8001 | 5024 | 161 |
344470 | 344470 | 2020-07-18 | Adams | Colorado | 8001 | 5058 | 161 |
347670 | 347670 | 2020-07-19 | Adams | Colorado | 8001 | 5094 | 161 |
350871 | 350871 | 2020-07-20 | Adams | Colorado | 8001 | 5133 | 163 |
354073 | 354073 | 2020-07-21 | Adams | Colorado | 8001 | 5184 | 163 |
357276 | 357276 | 2020-07-22 | Adams | Colorado | 8001 | 5248 | 164 |
360481 | 360481 | 2020-07-23 | Adams | Colorado | 8001 | 5312 | 167 |
363688 | 363688 | 2020-07-24 | Adams | Colorado | 8001 | 5433 | 167 |
366895 | 366895 | 2020-07-25 | Adams | Colorado | 8001 | 5535 | 167 |
370105 | 370105 | 2020-07-26 | Adams | Colorado | 8001 | 5587 | 167 |
373317 | 373317 | 2020-07-27 | Adams | Colorado | 8001 | 5626 | 167 |
376531 | 376531 | 2020-07-28 | Adams | Colorado | 8001 | 5713 | 168 |
379748 | 379748 | 2020-07-29 | Adams | Colorado | 8001 | 5794 | 168 |
382965 | 382965 | 2020-07-30 | Adams | Colorado | 8001 | 5868 | 168 |
386183 | 386183 | 2020-07-31 | Adams | Colorado | 8001 | 5957 | 171 |
389400 | 389400 | 2020-08-01 | Adams | Colorado | 8001 | 6018 | 171 |
392617 | 392617 | 2020-08-02 | Adams | Colorado | 8001 | 6084 | 171 |
395833 | 395833 | 2020-08-03 | Adams | Colorado | 8001 | 6115 | 171 |
399049 | 399049 | 2020-08-04 | Adams | Colorado | 8001 | 6181 | 173 |
402265 | 402265 | 2020-08-05 | Adams | Colorado | 8001 | 6248 | 175 |
405483 | 405483 | 2020-08-06 | Adams | Colorado | 8001 | 6307 | 175 |
408703 | 408703 | 2020-08-07 | Adams | Colorado | 8001 | 6375 | 176 |
411922 | 411922 | 2020-08-08 | Adams | Colorado | 8001 | 6438 | 176 |
415142 | 415142 | 2020-08-09 | Adams | Colorado | 8001 | 6491 | 176 |
418363 | 418363 | 2020-08-10 | Adams | Colorado | 8001 | 6529 | 176 |
421584 | 421584 | 2020-08-11 | Adams | Colorado | 8001 | 6581 | 177 |
424805 | 424805 | 2020-08-12 | Adams | Colorado | 8001 | 6621 | 176 |
428029 | 428029 | 2020-08-13 | Adams | Colorado | 8001 | 6677 | 178 |
431257 | 431257 | 2020-08-14 | Adams | Colorado | 8001 | 6721 | 181 |
434482 | 434482 | 2020-08-15 | Adams | Colorado | 8001 | 6771 | 183 |
437708 | 437708 | 2020-08-16 | Adams | Colorado | 8001 | 6816 | 184 |
440934 | 440934 | 2020-08-17 | Adams | Colorado | 8001 | 6848 | 184 |
444160 | 444160 | 2020-08-18 | Adams | Colorado | 8001 | 6899 | 185 |
447387 | 447387 | 2020-08-19 | Adams | Colorado | 8001 | 6967 | 186 |
450615 | 450615 | 2020-08-20 | Adams | Colorado | 8001 | 7021 | 186 |
453843 | 453843 | 2020-08-21 | Adams | Colorado | 8001 | 7078 | 189 |
457071 | 457071 | 2020-08-22 | Adams | Colorado | 8001 | 7132 | 194 |
460298 | 460298 | 2020-08-23 | Adams | Colorado | 8001 | 7213 | 194 |
463527 | 463527 | 2020-08-24 | Adams | Colorado | 8001 | 7257 | 194 |
466756 | 466756 | 2020-08-25 | Adams | Colorado | 8001 | 7334 | 196 |
469985 | 469985 | 2020-08-26 | Adams | Colorado | 8001 | 7360 | 196 |
473217 | 473217 | 2020-08-27 | Adams | Colorado | 8001 | 7407 | 196 |
476450 | 476450 | 2020-08-28 | Adams | Colorado | 8001 | 7495 | 197 |
479683 | 479683 | 2020-08-29 | Adams | Colorado | 8001 | 7495 | 197 |
482917 | 482917 | 2020-08-30 | Adams | Colorado | 8001 | 7541 | 197 |
486152 | 486152 | 2020-08-31 | Adams | Colorado | 8001 | 7579 | 197 |
489385 | 489385 | 2020-09-01 | Adams | Colorado | 8001 | 7647 | 197 |
492618 | 492618 | 2020-09-02 | Adams | Colorado | 8001 | 7689 | 198 |
495852 | 495852 | 2020-09-03 | Adams | Colorado | 8001 | 7731 | 200 |
499085 | 499085 | 2020-09-04 | Adams | Colorado | 8001 | 7778 | 206 |
502319 | 502319 | 2020-09-05 | Adams | Colorado | 8001 | 7834 | 208 |
505553 | 505553 | 2020-09-06 | Adams | Colorado | 8001 | 7860 | 208 |
508785 | 508785 | 2020-09-07 | Adams | Colorado | 8001 | 7891 | 209 |
512018 | 512018 | 2020-09-08 | Adams | Colorado | 8001 | 7912 | 209 |
515251 | 515251 | 2020-09-09 | Adams | Colorado | 8001 | 7954 | 209 |
518486 | 518486 | 2020-09-10 | Adams | Colorado | 8001 | 7997 | 209 |
521723 | 521723 | 2020-09-11 | Adams | Colorado | 8001 | 8025 | 211 |
524959 | 524959 | 2020-09-12 | Adams | Colorado | 8001 | 8063 | 211 |
528195 | 528195 | 2020-09-13 | Adams | Colorado | 8001 | 8104 | 211 |
531432 | 531432 | 2020-09-14 | Adams | Colorado | 8001 | 8143 | 211 |
534667 | 534667 | 2020-09-15 | Adams | Colorado | 8001 | 8206 | 213 |
537903 | 537903 | 2020-09-16 | Adams | Colorado | 8001 | 8260 | 213 |
541140 | 541140 | 2020-09-17 | Adams | Colorado | 8001 | 8327 | 216 |
544376 | 544376 | 2020-09-18 | Adams | Colorado | 8001 | 8418 | 218 |
547614 | 547614 | 2020-09-19 | Adams | Colorado | 8001 | 8442 | 220 |
550853 | 550853 | 2020-09-20 | Adams | Colorado | 8001 | 8468 | 221 |
554092 | 554092 | 2020-09-21 | Adams | Colorado | 8001 | 8578 | 221 |
557329 | 557329 | 2020-09-22 | Adams | Colorado | 8001 | 8622 | 222 |
560565 | 560565 | 2020-09-23 | Adams | Colorado | 8001 | 8748 | 222 |
563804 | 563804 | 2020-09-24 | Adams | Colorado | 8001 | 8804 | 224 |
567044 | 567044 | 2020-09-25 | Adams | Colorado | 8001 | 8947 | 225 |
570286 | 570286 | 2020-09-26 | Adams | Colorado | 8001 | 9011 | 225 |
573528 | 573528 | 2020-09-27 | Adams | Colorado | 8001 | 9106 | 225 |
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);