ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,925 rows where county = "Pierce" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 5
- Washington 354
- Wisconsin 351
- North Dakota 340
- Georgia 337
- Nebraska 318
county 1
- Pierce · 1,700 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054008 | 1054008 | 2021-02-22 | Pierce | Georgia | 13229 | 2293 | 50 |
1055245 | 1055245 | 2021-02-22 | Pierce | Nebraska | 31139 | 598 | 20 |
1055544 | 1055544 | 2021-02-22 | Pierce | North Dakota | 38069 | 519 | 24 |
1056589 | 1056589 | 2021-02-22 | Pierce | Washington | 53053 | 37897 | 532 |
1056704 | 1056704 | 2021-02-22 | Pierce | Wisconsin | 55093 | 4315 | 39 |
1050761 | 1050761 | 2021-02-21 | Pierce | Georgia | 13229 | 2293 | 50 |
1051998 | 1051998 | 2021-02-21 | Pierce | Nebraska | 31139 | 598 | 20 |
1052298 | 1052298 | 2021-02-21 | Pierce | North Dakota | 38069 | 519 | 24 |
1053343 | 1053343 | 2021-02-21 | Pierce | Washington | 53053 | 37574 | 527 |
1053458 | 1053458 | 2021-02-21 | Pierce | Wisconsin | 55093 | 4315 | 39 |
1047514 | 1047514 | 2021-02-20 | Pierce | Georgia | 13229 | 2293 | 50 |
1048751 | 1048751 | 2021-02-20 | Pierce | Nebraska | 31139 | 598 | 20 |
1049051 | 1049051 | 2021-02-20 | Pierce | North Dakota | 38069 | 519 | 24 |
1050096 | 1050096 | 2021-02-20 | Pierce | Washington | 53053 | 37574 | 527 |
1050211 | 1050211 | 2021-02-20 | Pierce | Wisconsin | 55093 | 4312 | 39 |
1044269 | 1044269 | 2021-02-19 | Pierce | Georgia | 13229 | 2290 | 49 |
1045505 | 1045505 | 2021-02-19 | Pierce | Nebraska | 31139 | 600 | 20 |
1045804 | 1045804 | 2021-02-19 | Pierce | North Dakota | 38069 | 519 | 24 |
1046849 | 1046849 | 2021-02-19 | Pierce | Washington | 53053 | 37574 | 527 |
1046964 | 1046964 | 2021-02-19 | Pierce | Wisconsin | 55093 | 4310 | 39 |
1041024 | 1041024 | 2021-02-18 | Pierce | Georgia | 13229 | 2277 | 49 |
1042260 | 1042260 | 2021-02-18 | Pierce | Nebraska | 31139 | 600 | 20 |
1042559 | 1042559 | 2021-02-18 | Pierce | North Dakota | 38069 | 519 | 24 |
1043604 | 1043604 | 2021-02-18 | Pierce | Washington | 53053 | 37466 | 525 |
1043719 | 1043719 | 2021-02-18 | Pierce | Wisconsin | 55093 | 4301 | 39 |
1037779 | 1037779 | 2021-02-17 | Pierce | Georgia | 13229 | 2267 | 49 |
1039015 | 1039015 | 2021-02-17 | Pierce | Nebraska | 31139 | 597 | 20 |
1039314 | 1039314 | 2021-02-17 | Pierce | North Dakota | 38069 | 518 | 24 |
1040359 | 1040359 | 2021-02-17 | Pierce | Washington | 53053 | 37357 | 519 |
1040474 | 1040474 | 2021-02-17 | Pierce | Wisconsin | 55093 | 4295 | 39 |
1034534 | 1034534 | 2021-02-16 | Pierce | Georgia | 13229 | 2259 | 48 |
1035770 | 1035770 | 2021-02-16 | Pierce | Nebraska | 31139 | 597 | 20 |
1036069 | 1036069 | 2021-02-16 | Pierce | North Dakota | 38069 | 517 | 24 |
1037114 | 1037114 | 2021-02-16 | Pierce | Washington | 53053 | 37194 | 510 |
1037229 | 1037229 | 2021-02-16 | Pierce | Wisconsin | 55093 | 4291 | 39 |
1031288 | 1031288 | 2021-02-15 | Pierce | Georgia | 13229 | 2255 | 48 |
1032525 | 1032525 | 2021-02-15 | Pierce | Nebraska | 31139 | 596 | 20 |
1032824 | 1032824 | 2021-02-15 | Pierce | North Dakota | 38069 | 514 | 24 |
1033869 | 1033869 | 2021-02-15 | Pierce | Washington | 53053 | 36753 | 507 |
1033984 | 1033984 | 2021-02-15 | Pierce | Wisconsin | 55093 | 4284 | 39 |
1028041 | 1028041 | 2021-02-14 | Pierce | Georgia | 13229 | 2253 | 48 |
1029278 | 1029278 | 2021-02-14 | Pierce | Nebraska | 31139 | 596 | 20 |
1029578 | 1029578 | 2021-02-14 | Pierce | North Dakota | 38069 | 513 | 24 |
1030623 | 1030623 | 2021-02-14 | Pierce | Washington | 53053 | 36753 | 507 |
1030738 | 1030738 | 2021-02-14 | Pierce | Wisconsin | 55093 | 4282 | 39 |
1024796 | 1024796 | 2021-02-13 | Pierce | Georgia | 13229 | 2252 | 48 |
1026032 | 1026032 | 2021-02-13 | Pierce | Nebraska | 31139 | 596 | 20 |
1026331 | 1026331 | 2021-02-13 | Pierce | North Dakota | 38069 | 513 | 24 |
1027376 | 1027376 | 2021-02-13 | Pierce | Washington | 53053 | 36753 | 507 |
1027491 | 1027491 | 2021-02-13 | Pierce | Wisconsin | 55093 | 4277 | 39 |
1021551 | 1021551 | 2021-02-12 | Pierce | Georgia | 13229 | 2246 | 46 |
1022787 | 1022787 | 2021-02-12 | Pierce | Nebraska | 31139 | 596 | 20 |
1023086 | 1023086 | 2021-02-12 | Pierce | North Dakota | 38069 | 513 | 24 |
1024131 | 1024131 | 2021-02-12 | Pierce | Washington | 53053 | 36753 | 507 |
1024246 | 1024246 | 2021-02-12 | Pierce | Wisconsin | 55093 | 4272 | 39 |
1018306 | 1018306 | 2021-02-11 | Pierce | Georgia | 13229 | 2240 | 45 |
1019542 | 1019542 | 2021-02-11 | Pierce | Nebraska | 31139 | 595 | 20 |
1019841 | 1019841 | 2021-02-11 | Pierce | North Dakota | 38069 | 513 | 24 |
1020886 | 1020886 | 2021-02-11 | Pierce | Washington | 53053 | 36546 | 503 |
1021001 | 1021001 | 2021-02-11 | Pierce | Wisconsin | 55093 | 4263 | 39 |
1015061 | 1015061 | 2021-02-10 | Pierce | Georgia | 13229 | 2240 | 45 |
1016297 | 1016297 | 2021-02-10 | Pierce | Nebraska | 31139 | 595 | 20 |
1016596 | 1016596 | 2021-02-10 | Pierce | North Dakota | 38069 | 512 | 24 |
1017641 | 1017641 | 2021-02-10 | Pierce | Washington | 53053 | 36488 | 501 |
1017756 | 1017756 | 2021-02-10 | Pierce | Wisconsin | 55093 | 4258 | 39 |
1011816 | 1011816 | 2021-02-09 | Pierce | Georgia | 13229 | 2230 | 45 |
1013052 | 1013052 | 2021-02-09 | Pierce | Nebraska | 31139 | 592 | 20 |
1013351 | 1013351 | 2021-02-09 | Pierce | North Dakota | 38069 | 513 | 24 |
1014396 | 1014396 | 2021-02-09 | Pierce | Washington | 53053 | 36258 | 496 |
1014511 | 1014511 | 2021-02-09 | Pierce | Wisconsin | 55093 | 4241 | 39 |
1008570 | 1008570 | 2021-02-08 | Pierce | Georgia | 13229 | 2226 | 44 |
1009807 | 1009807 | 2021-02-08 | Pierce | Nebraska | 31139 | 588 | 20 |
1010106 | 1010106 | 2021-02-08 | Pierce | North Dakota | 38069 | 513 | 24 |
1011151 | 1011151 | 2021-02-08 | Pierce | Washington | 53053 | 36180 | 483 |
1011266 | 1011266 | 2021-02-08 | Pierce | Wisconsin | 55093 | 4227 | 39 |
1005324 | 1005324 | 2021-02-07 | Pierce | Georgia | 13229 | 2225 | 44 |
1006560 | 1006560 | 2021-02-07 | Pierce | Nebraska | 31139 | 588 | 20 |
1006860 | 1006860 | 2021-02-07 | Pierce | North Dakota | 38069 | 513 | 24 |
1007905 | 1007905 | 2021-02-07 | Pierce | Washington | 53053 | 35849 | 484 |
1008020 | 1008020 | 2021-02-07 | Pierce | Wisconsin | 55093 | 4227 | 39 |
1002078 | 1002078 | 2021-02-06 | Pierce | Georgia | 13229 | 2224 | 44 |
1003314 | 1003314 | 2021-02-06 | Pierce | Nebraska | 31139 | 587 | 20 |
1003614 | 1003614 | 2021-02-06 | Pierce | North Dakota | 38069 | 513 | 24 |
1004659 | 1004659 | 2021-02-06 | Pierce | Washington | 53053 | 35849 | 484 |
1004774 | 1004774 | 2021-02-06 | Pierce | Wisconsin | 55093 | 4217 | 39 |
998832 | 998832 | 2021-02-05 | Pierce | Georgia | 13229 | 2216 | 44 |
1000069 | 1000069 | 2021-02-05 | Pierce | Nebraska | 31139 | 587 | 20 |
1000368 | 1000368 | 2021-02-05 | Pierce | North Dakota | 38069 | 513 | 24 |
1001413 | 1001413 | 2021-02-05 | Pierce | Washington | 53053 | 35849 | 484 |
1001528 | 1001528 | 2021-02-05 | Pierce | Wisconsin | 55093 | 4200 | 39 |
995586 | 995586 | 2021-02-04 | Pierce | Georgia | 13229 | 2208 | 44 |
996823 | 996823 | 2021-02-04 | Pierce | Nebraska | 31139 | 586 | 20 |
997122 | 997122 | 2021-02-04 | Pierce | North Dakota | 38069 | 513 | 24 |
998167 | 998167 | 2021-02-04 | Pierce | Washington | 53053 | 35718 | 481 |
998282 | 998282 | 2021-02-04 | Pierce | Wisconsin | 55093 | 4193 | 38 |
992340 | 992340 | 2021-02-03 | Pierce | Georgia | 13229 | 2202 | 43 |
993577 | 993577 | 2021-02-03 | Pierce | Nebraska | 31139 | 582 | 20 |
993876 | 993876 | 2021-02-03 | Pierce | North Dakota | 38069 | 513 | 24 |
994921 | 994921 | 2021-02-03 | Pierce | Washington | 53053 | 35554 | 477 |
995036 | 995036 | 2021-02-03 | Pierce | Wisconsin | 55093 | 4178 | 38 |
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);