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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 663 ✖
- 1 6
- 3 6
- 351 4
- 45002 4
- 14302 3
- 19723 3
- 19810 3
- 19935 3
- 20064 3
- 20245 3
- 20442 3
- 20698 3
- 21038 3
- 21365 3
- 21831 3
- 22255 3
- 22702 3
- 23247 3
- 23954 3
- 24665 3
- 25691 3
- 26736 3
- 27743 3
- 28613 3
- 29192 3
- 29805 3
- 30308 3
- 30667 3
- 30980 3
- 31666 3
- 32885 3
- 36164 3
- 39121 3
- 42383 3
- 43099 3
- 43627 3
- 43914 3
- 44212 3
- 44695 3
- 45456 3
- 45758 3
- 46123 3
- 46477 3
- 46810 3
- 47036 3
- 47154 3
- 21 2
- 28 2
- 39 2
- 44 2
- 46 2
- 64 2
- 136 2
- 158 2
- 188 2
- 263 2
- 278 2
- 297 2
- 320 2
- 352 2
- 358 2
- 393 2
- 798 2
- 11415 2
- 13541 2
- 14177 2
- 14353 2
- 14945 2
- 15177 2
- 16093 2
- 17382 2
- 19753 2
- 19850 2
- 40989 2
- 41282 2
- 2 1
- 5 1
- 7 1
- 9 1
- 18 1
- 48 1
- 50 1
- 53 1
- 58 1
- 68 1
- 72 1
- 78 1
- 84 1
- 87 1
- 88 1
- 92 1
- 107 1
- 108 1
- 116 1
- 121 1
- 131 1
- 134 1
- 139 1
- 146 1
- 150 1
- 157 1
- 161 1
- 163 1
- 170 1
- 176 1
- 182 1
- 185 1
- 186 1
- 195 1
- 202 1
- 204 1
- 217 1
- 219 1
- 220 1
- 230 1
- 233 1
- 260 1
- 264 1
- 281 1
- 289 1
- 295 1
- 300 1
- 302 1
- 306 1
- 313 1
- 323 1
- 324 1
- 326 1
- 332 1
- 346 1
- 355 1
- 357 1
- 368 1
- 369 1
- 372 1
- 378 1
- 383 1
- 385 1
- 390 1
- 396 1
- 404 1
- 407 1
- 408 1
- 411 1
- 416 1
- 417 1
- 422 1
- 430 1
- 432 1
- 444 1
- 450 1
- 458 1
- 469 1
- 479 1
- 482 1
- 483 1
- 502 1
- 524 1
- 535 1
- 538 1
- 548 1
- 552 1
- 559 1
- 563 1
- 575 1
- 577 1
- 590 1
- 597 1
- 611 1
- 613 1
- 615 1
- 617 1
- 645 1
- 660 1
- 674 1
- 687 1
- 693 1
- 699 1
- 709 1
- 711 1
- 723 1
- 729 1
- 750 1
- 754 1
- 757 1
- 760 1
- 770 1
- 779 1
- 789 1
- 802 1
- 806 1
- 821 1
- 841 1
- 859 1
- 865 1
- 866 1
- 868 1
- 875 1
- 886 1
- 895 1
- 905 1
- 920 1
- 928 1
- 929 1
- 936 1
- 951 1
- 960 1
- 965 1
- 969 1
- 974 1
- 980 1
- 989 1
- 1001 1
- 1003 1
- 1014 1
- 1024 1
- 1035 1
- 1037 1
- 1041 1
- 1052 1
- 1060 1
- 1072 1
- 1079 1
- 1090 1
- 1091 1
- 1114 1
- 1129 1
- 1146 1
- 1159 1
- 1176 1
- 1197 1
- 1213 1
- 1217 1
- 1259 1
- 1284 1
- 1317 1
- 1332 1
- 1369 1
- 1370 1
- 1406 1
- 1439 1
- 1492 1
- 1514 1
- 1544 1
- 1582 1
- 1613 1
- 1631 1
- 1697 1
- 1725 1
- 1762 1
- 1790 1
- 1904 1
- 1982 1
- 2047 1
- 2096 1
- 2141 1
- 2227 1
- 2331 1
- 2436 1
- 2509 1
- 2635 1
- 2721 1
- 2826 1
- 2964 1
- 3081 1
- 3160 1
- 3283 1
- 3436 1
- 3693 1
- 3982 1
- 4267 1
- 4585 1
- 4860 1
- 5061 1
- 5275 1
- 5516 1
- 5736 1
- 6110 1
- 6450 1
- 6738 1
- 7028 1
- 7195 1
- 7429 1
- 7602 1
- 7860 1
- 8077 1
- 8269 1
- 8594 1
- 8856 1
- 9048 1
- 9335 1
- 9540 1
- 9749 1
- 9884 1
- 10126 1
- 10360 1
- 10650 1
- 10946 1
- 11189 1
- 11353 1
- 11705 1
- 11869 1
- 11990 1
- 12150 1
- 12236 1
- 12320 1
- 12407 1
- 12498 1
- 12619 1
- 12744 1
- 12827 1
- 12854 1
- 12884 1
- 12955 1
- 12991 1
- 13103 1
- 13218 1
- 13328 1
- 13375 1
- 13425 1
- 13523 1
- 13634 1
- 13679 1
- 13763 1
- 13802 1
- 13843 1
- 13862 1
- 13894 1
- 13930 1
- 13968 1
- 13991 1
- 14009 1
- 14024 1
- 14046 1
- 14086 1
- 14113 1
- 14131 1
- 14159 1
- 14199 1
- 14230 1
- 14246 1
- 14381 1
- 14389 1
- 14407 1
- 14426 1
- 14441 1
- 14449 1
- 14451 1
- 14452 1
- 14461 1
- 14727 1
- 14787 1
- 14794 1
- 14796 1
- 14802 1
- 14814 1
- 14839 1
- 14853 1
- 14874 1
- 14879 1
- 14881 1
- 14900 1
- 14907 1
- 14995 1
- 15007 1
- 15046 1
- 15058 1
- 15110 1
- 15134 1
- 15167 1
- 15195 1
- 15250 1
- 15266 1
- 15279 1
- 15306 1
- 15328 1
- 15350 1
- 15357 1
- 15364 1
- 15399 1
- 15427 1
- 15453 1
- 15479 1
- 15495 1
- 15498 1
- 15518 1
- 15552 1
- 15578 1
- 15614 1
- 15651 1
- 15691 1
- 15748 1
- 15766 1
- 15830 1
- 15876 1
- 15945 1
- 15986 1
- 16045 1
- 16075 1
- 16216 1
- 16263 1
- 16338 1
- 16399 1
- 16449 1
- 16540 1
- 16607 1
- 16640 1
- 16716 1
- 16788 1
- 16825 1
- 16867 1
- 16921 1
- 16978 1
- 17135 1
- 17218 1
- 17316 1
- 17475 1
- 17563 1
- 17717 1
- 17799 1
- 17906 1
- 17982 1
- 18040 1
- 18151 1
- 18252 1
- 18331 1
- 18397 1
- 18457 1
- 18498 1
- 18534 1
- 18566 1
- 18609 1
- 18660 1
- 18691 1
- 18724 1
- 18747 1
- 18770 1
- 18786 1
- 18818 1
- 18855 1
- 18870 1
- 18884 1
- 18894 1
- 18908 1
- 18963 1
- 19001 1
- 19030 1
- 19055 1
- 19079 1
- 19088 1
- 19094 1
- 19101 1
- 19118 1
- 19156 1
- 19174 1
- 19190 1
- 19202 1
- 19211 1
- 19218 1
- 19241 1
- 19264 1
- 19341 1
- 19369 1
- 19387 1
- 19396 1
- 19406 1
- 19409 1
- 19425 1
- 19447 1
- 19484 1
- 19495 1
- 19500 1
- 19513 1
- 19521 1
- 19537 1
- 19559 1
- 19569 1
- 19571 1
- 19573 1
- 19581 1
- 19588 1
- 19599 1
- 19618 1
- 19624 1
- 19628 1
- 19633 1
- 19640 1
- 19648 1
- 19653 1
- 19673 1
- 19675 1
- 19678 1
- 19680 1
- 19693 1
- 19702 1
- 19715 1
- 19786 1
- 19801 1
- 19884 1
- 19909 1
- 19977 1
- 19993 1
- 20010 1
- 20022 1
- 20137 1
- 20160 1
- 20192 1
- 20223 1
- 20313 1
- 20347 1
- 20377 1
- 20412 1
- 20555 1
- 20574 1
- 20610 1
- 20633 1
- 20785 1
- 20846 1
- 20907 1
- 20963 1
- 21151 1
- 21203 1
- 21233 1
- 21289 1
- 21568 1
- 21636 1
- 21704 1
- 21763 1
- 21977 1
- 22041 1
- 22084 1
- 22181 1
- 22415 1
- 22479 1
- 22509 1
- 22587 1
- 22856 1
- 22951 1
- 23008 1
- 23115 1
- 23473 1
- 23576 1
- 23681 1
- 23849 1
- 24164 1
- 24262 1
- 24342 1
- 24532 1
- 25025 1
- 25140 1
- 25324 1
- 25521 1
- 26086 1
- 26175 1
- 26336 1
- 26555 1
- 27084 1
- 27212 1
- 27434 1
- 27607 1
- 28076 1
- 28175 1
- 28340 1
- 28484 1
- 28867 1
- 28954 1
- 29085 1
- 29234 1
- 29383 1
- 29441 1
- 29596 1
- 29695 1
- 29969 1
- 30071 1
- 30160 1
- 30254 1
- 30421 1
- 30460 1
- 30545 1
- 30615 1
- 30739 1
- 30793 1
- 30863 1
- 30920 1
- 31139 1
- 31211 1
- 31340 1
- 31496 1
- 32142 1
- 32354 1
- 32484 1
- 32646 1
- 34155 1
- 34724 1
- 35077 1
- 35565 1
- 37341 1
- 37800 1
- 38120 1
- 38733 1
- 40270 1
- 40442 1
- 40640 1
- 41721 1
- 41915 1
- 42073 1
- 42284 1
- 42672 1
- 42761 1
- 42869 1
- 42970 1
- 43271 1
- 43345 1
- 43431 1
- 43519 1
- 43719 1
- 43732 1
- 43801 1
- 43865 1
- 43991 1
- 44036 1
- 44067 1
- 44155 1
- 44361 1
- 44459 1
- 44523 1
- 44609 1
- 44774 1
- 44818 1
- 44903 1
- 45226 1
- 45293 1
- 45334 1
- 45399 1
- 45487 1
- 45539 1
- 45605 1
- 45665 1
- 45826 1
- 45860 1
- 45934 1
- 45967 1
- 46228 1
- 46242 1
- 46317 1
- 46405 1
- 46562 1
- 46616 1
- 46665 1
- 46743 1
- 46893 1
- 46915 1
- 47000 1
- 47026 1
- 47056 1
- 47072 1
- 47087 1
- 47112 1
- 47210 1
- 47224 1
- 47261 1
- 47647 1
- 47690 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);