ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Pueblo" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 268 ✖
- 34 56
- 37 21
- 365 20
- 774 20
- 427 15
- 0 14
- 364 13
- 363 12
- 366 11
- 14 10
- 423 10
- 30 9
- 40 9
- 2 8
- 18 8
- 362 8
- 392 8
- 418 8
- 773 8
- 782 8
- 3 7
- 12 7
- 32 7
- 356 7
- 428 7
- 23 6
- 33 6
- 361 6
- 383 6
- 449 6
- 769 6
- 771 6
- 9 5
- 10 5
- 28 5
- 420 5
- 432 5
- 453 5
- 680 5
- 800 5
- 7 4
- 13 4
- 22 4
- 31 4
- 41 4
- 355 4
- 360 4
- 415 4
- 422 4
- 483 4
- 525 4
- 576 4
- 708 4
- 734 4
- 756 4
- 763 4
- 775 4
- 1 3
- 11 3
- 26 3
- 45 3
- 65 3
- 80 3
- 115 3
- 334 3
- 335 3
- 342 3
- 359 3
- 367 3
- 369 3
- 377 3
- 393 3
- 399 3
- 403 3
- 414 3
- 417 3
- 425 3
- 435 3
- 441 3
- 446 3
- 460 3
- 464 3
- 470 3
- 495 3
- 512 3
- 553 3
- 594 3
- 619 3
- 639 3
- 652 3
- 669 3
- 699 3
- 720 3
- 758 3
- 760 3
- 776 3
- 777 3
- 781 3
- 4 2
- 6 2
- 16 2
- 19 2
- 39 2
- 54 2
- 60 2
- 216 2
- 270 2
- 288 2
- 330 2
- 371 2
- 391 2
- 396 2
- 400 2
- 411 2
- 412 2
- 416 2
- 424 2
- 431 2
- 434 2
- 436 2
- 442 2
- 443 2
- 448 2
- 451 2
- 456 2
- 467 2
- 469 2
- 487 2
- 504 2
- 691 2
- 700 2
- 724 2
- 762 2
- 799 2
- 801 2
- 802 2
- 5 1
- 8 1
- 15 1
- 17 1
- 20 1
- 24 1
- 36 1
- 38 1
- 44 1
- 47 1
- 48 1
- 50 1
- 52 1
- 53 1
- 59 1
- 61 1
- 66 1
- 69 1
- 70 1
- 81 1
- 82 1
- 96 1
- 109 1
- 117 1
- 121 1
- 131 1
- 140 1
- 149 1
- 150 1
- 153 1
- 154 1
- 155 1
- 156 1
- 184 1
- 204 1
- 211 1
- 212 1
- 237 1
- 241 1
- 249 1
- 256 1
- 266 1
- 267 1
- 280 1
- 286 1
- 287 1
- 297 1
- 300 1
- 302 1
- 304 1
- 313 1
- 322 1
- 325 1
- 326 1
- 336 1
- 338 1
- 339 1
- 340 1
- 352 1
- 354 1
- 357 1
- 374 1
- 376 1
- 382 1
- 388 1
- 394 1
- 395 1
- 402 1
- 405 1
- 429 1
- 437 1
- 440 1
- 450 1
- 459 1
- 461 1
- 462 1
- 463 1
- 474 1
- 479 1
- 480 1
- 491 1
- 494 1
- 500 1
- 507 1
- 518 1
- 519 1
- 523 1
- 535 1
- 542 1
- 545 1
- 551 1
- 560 1
- 569 1
- 581 1
- 582 1
- 587 1
- 589 1
- 593 1
- 596 1
- 604 1
- 610 1
- 618 1
- 625 1
- 629 1
- 633 1
- 637 1
- 643 1
- 647 1
- 649 1
- 650 1
- 653 1
- 660 1
- 664 1
- 666 1
- 672 1
- 677 1
- 678 1
- 695 1
- 705 1
- 710 1
- 719 1
- 727 1
- 731 1
- 732 1
- 746 1
- 748 1
- 753 1
- 759 1
- 761 1
- 766 1
- 770 1
- 778 1
state 1
- Colorado 792
fips 1
- 8101 792
county 1
- Pueblo · 792 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1668 | 1668 | 2020-03-13 | Pueblo | Colorado | 8101 | 1 | 0 |
1988 | 1988 | 2020-03-14 | Pueblo | Colorado | 8101 | 1 | 0 |
2370 | 2370 | 2020-03-15 | Pueblo | Colorado | 8101 | 1 | 0 |
2805 | 2805 | 2020-03-16 | Pueblo | Colorado | 8101 | 1 | 0 |
3287 | 3287 | 2020-03-17 | Pueblo | Colorado | 8101 | 1 | 0 |
3841 | 3841 | 2020-03-18 | Pueblo | Colorado | 8101 | 1 | 0 |
4504 | 4504 | 2020-03-19 | Pueblo | Colorado | 8101 | 2 | 0 |
5281 | 5281 | 2020-03-20 | Pueblo | Colorado | 8101 | 3 | 0 |
6208 | 6208 | 2020-03-21 | Pueblo | Colorado | 8101 | 3 | 0 |
7243 | 7243 | 2020-03-22 | Pueblo | Colorado | 8101 | 3 | 0 |
8388 | 8388 | 2020-03-23 | Pueblo | Colorado | 8101 | 3 | 0 |
9633 | 9633 | 2020-03-24 | Pueblo | Colorado | 8101 | 3 | 0 |
11007 | 11007 | 2020-03-25 | Pueblo | Colorado | 8101 | 3 | 0 |
12553 | 12553 | 2020-03-26 | Pueblo | Colorado | 8101 | 5 | 0 |
14222 | 14222 | 2020-03-27 | Pueblo | Colorado | 8101 | 7 | 1 |
16006 | 16006 | 2020-03-28 | Pueblo | Colorado | 8101 | 9 | 1 |
17898 | 17898 | 2020-03-29 | Pueblo | Colorado | 8101 | 18 | 1 |
19877 | 19877 | 2020-03-30 | Pueblo | Colorado | 8101 | 21 | 2 |
21953 | 21953 | 2020-03-31 | Pueblo | Colorado | 8101 | 21 | 2 |
24112 | 24112 | 2020-04-01 | Pueblo | Colorado | 8101 | 28 | 2 |
26342 | 26342 | 2020-04-02 | Pueblo | Colorado | 8101 | 28 | 2 |
28643 | 28643 | 2020-04-03 | Pueblo | Colorado | 8101 | 39 | 2 |
31001 | 31001 | 2020-04-04 | Pueblo | Colorado | 8101 | 39 | 2 |
33407 | 33407 | 2020-04-05 | Pueblo | Colorado | 8101 | 44 | 2 |
35852 | 35852 | 2020-04-06 | Pueblo | Colorado | 8101 | 44 | 2 |
38342 | 38342 | 2020-04-07 | Pueblo | Colorado | 8101 | 46 | 3 |
40885 | 40885 | 2020-04-08 | Pueblo | Colorado | 8101 | 46 | 3 |
43459 | 43459 | 2020-04-09 | Pueblo | Colorado | 8101 | 48 | 3 |
46059 | 46059 | 2020-04-10 | Pueblo | Colorado | 8101 | 50 | 3 |
48689 | 48689 | 2020-04-11 | Pueblo | Colorado | 8101 | 53 | 3 |
51351 | 51351 | 2020-04-12 | Pueblo | Colorado | 8101 | 58 | 3 |
54030 | 54030 | 2020-04-13 | Pueblo | Colorado | 8101 | 64 | 3 |
56722 | 56722 | 2020-04-14 | Pueblo | Colorado | 8101 | 64 | 4 |
59430 | 59430 | 2020-04-15 | Pueblo | Colorado | 8101 | 68 | 4 |
62149 | 62149 | 2020-04-16 | Pueblo | Colorado | 8101 | 72 | 5 |
64882 | 64882 | 2020-04-17 | Pueblo | Colorado | 8101 | 78 | 6 |
67630 | 67630 | 2020-04-18 | Pueblo | Colorado | 8101 | 84 | 6 |
70392 | 70392 | 2020-04-19 | Pueblo | Colorado | 8101 | 87 | 7 |
73161 | 73161 | 2020-04-20 | Pueblo | Colorado | 8101 | 88 | 7 |
75937 | 75937 | 2020-04-21 | Pueblo | Colorado | 8101 | 92 | 7 |
78721 | 78721 | 2020-04-22 | Pueblo | Colorado | 8101 | 107 | 7 |
81515 | 81515 | 2020-04-23 | Pueblo | Colorado | 8101 | 108 | 8 |
84315 | 84315 | 2020-04-24 | Pueblo | Colorado | 8101 | 116 | 9 |
87123 | 87123 | 2020-04-25 | Pueblo | Colorado | 8101 | 121 | 9 |
89940 | 89940 | 2020-04-26 | Pueblo | Colorado | 8101 | 131 | 9 |
92758 | 92758 | 2020-04-27 | Pueblo | Colorado | 8101 | 134 | 9 |
95590 | 95590 | 2020-04-28 | Pueblo | Colorado | 8101 | 136 | 9 |
98435 | 98435 | 2020-04-29 | Pueblo | Colorado | 8101 | 136 | 10 |
101285 | 101285 | 2020-04-30 | Pueblo | Colorado | 8101 | 139 | 10 |
104140 | 104140 | 2020-05-01 | Pueblo | Colorado | 8101 | 146 | 10 |
107005 | 107005 | 2020-05-02 | Pueblo | Colorado | 8101 | 150 | 10 |
109874 | 109874 | 2020-05-03 | Pueblo | Colorado | 8101 | 158 | 10 |
112749 | 112749 | 2020-05-04 | Pueblo | Colorado | 8101 | 157 | 11 |
115632 | 115632 | 2020-05-05 | Pueblo | Colorado | 8101 | 158 | 11 |
118591 | 118591 | 2020-05-06 | Pueblo | Colorado | 8101 | 161 | 11 |
121560 | 121560 | 2020-05-07 | Pueblo | Colorado | 8101 | 163 | 12 |
124540 | 124540 | 2020-05-08 | Pueblo | Colorado | 8101 | 170 | 12 |
127526 | 127526 | 2020-05-09 | Pueblo | Colorado | 8101 | 176 | 12 |
130517 | 130517 | 2020-05-10 | Pueblo | Colorado | 8101 | 182 | 12 |
133508 | 133508 | 2020-05-11 | Pueblo | Colorado | 8101 | 185 | 12 |
136497 | 136497 | 2020-05-12 | Pueblo | Colorado | 8101 | 188 | 12 |
139488 | 139488 | 2020-05-13 | Pueblo | Colorado | 8101 | 188 | 12 |
142484 | 142484 | 2020-05-14 | Pueblo | Colorado | 8101 | 186 | 13 |
145484 | 145484 | 2020-05-15 | Pueblo | Colorado | 8101 | 195 | 13 |
148487 | 148487 | 2020-05-16 | Pueblo | Colorado | 8101 | 202 | 13 |
151496 | 151496 | 2020-05-17 | Pueblo | Colorado | 8101 | 204 | 13 |
154508 | 154508 | 2020-05-18 | Pueblo | Colorado | 8101 | 217 | 14 |
157524 | 157524 | 2020-05-19 | Pueblo | Colorado | 8101 | 219 | 14 |
160550 | 160550 | 2020-05-20 | Pueblo | Colorado | 8101 | 220 | 14 |
163578 | 163578 | 2020-05-21 | Pueblo | Colorado | 8101 | 230 | 14 |
166611 | 166611 | 2020-05-22 | Pueblo | Colorado | 8101 | 233 | 14 |
169648 | 169648 | 2020-05-23 | Pueblo | Colorado | 8101 | 260 | 14 |
172689 | 172689 | 2020-05-24 | Pueblo | Colorado | 8101 | 263 | 14 |
175733 | 175733 | 2020-05-25 | Pueblo | Colorado | 8101 | 263 | 14 |
178777 | 178777 | 2020-05-26 | Pueblo | Colorado | 8101 | 264 | 14 |
181821 | 181821 | 2020-05-27 | Pueblo | Colorado | 8101 | 278 | 14 |
184875 | 184875 | 2020-05-28 | Pueblo | Colorado | 8101 | 278 | 15 |
187931 | 187931 | 2020-05-29 | Pueblo | Colorado | 8101 | 281 | 16 |
190996 | 190996 | 2020-05-30 | Pueblo | Colorado | 8101 | 289 | 16 |
194063 | 194063 | 2020-05-31 | Pueblo | Colorado | 8101 | 295 | 17 |
197133 | 197133 | 2020-06-01 | Pueblo | Colorado | 8101 | 297 | 18 |
200206 | 200206 | 2020-06-02 | Pueblo | Colorado | 8101 | 297 | 18 |
203282 | 203282 | 2020-06-03 | Pueblo | Colorado | 8101 | 300 | 18 |
206362 | 206362 | 2020-06-04 | Pueblo | Colorado | 8101 | 302 | 18 |
209443 | 209443 | 2020-06-05 | Pueblo | Colorado | 8101 | 306 | 18 |
212528 | 212528 | 2020-06-06 | Pueblo | Colorado | 8101 | 313 | 18 |
215615 | 215615 | 2020-06-07 | Pueblo | Colorado | 8101 | 320 | 18 |
218706 | 218706 | 2020-06-08 | Pueblo | Colorado | 8101 | 320 | 18 |
221801 | 221801 | 2020-06-09 | Pueblo | Colorado | 8101 | 323 | 19 |
224896 | 224896 | 2020-06-10 | Pueblo | Colorado | 8101 | 324 | 19 |
227998 | 227998 | 2020-06-11 | Pueblo | Colorado | 8101 | 326 | 20 |
231101 | 231101 | 2020-06-12 | Pueblo | Colorado | 8101 | 332 | 22 |
234207 | 234207 | 2020-06-13 | Pueblo | Colorado | 8101 | 346 | 22 |
237314 | 237314 | 2020-06-14 | Pueblo | Colorado | 8101 | 352 | 22 |
240422 | 240422 | 2020-06-15 | Pueblo | Colorado | 8101 | 352 | 22 |
243533 | 243533 | 2020-06-16 | Pueblo | Colorado | 8101 | 351 | 23 |
246646 | 246646 | 2020-06-17 | Pueblo | Colorado | 8101 | 351 | 23 |
249758 | 249758 | 2020-06-18 | Pueblo | Colorado | 8101 | 351 | 23 |
252873 | 252873 | 2020-06-19 | Pueblo | Colorado | 8101 | 351 | 23 |
255992 | 255992 | 2020-06-20 | Pueblo | Colorado | 8101 | 355 | 23 |
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);