ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,142 rows where county = "Lancaster" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 4
- South Carolina 794
- Pennsylvania 786
- Nebraska 785
- Virginia 777
county 1
- Lancaster · 3,142 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1317 | 1317 | 2020-03-11 | Lancaster | South Carolina | 45057 | 1 | 0 |
1563 | 1563 | 2020-03-12 | Lancaster | South Carolina | 45057 | 2 | 0 |
1863 | 1863 | 2020-03-13 | Lancaster | South Carolina | 45057 | 2 | 0 |
2226 | 2226 | 2020-03-14 | Lancaster | South Carolina | 45057 | 2 | 0 |
2651 | 2651 | 2020-03-15 | Lancaster | South Carolina | 45057 | 2 | 0 |
3117 | 3117 | 2020-03-16 | Lancaster | South Carolina | 45057 | 2 | 0 |
3648 | 3648 | 2020-03-17 | Lancaster | South Carolina | 45057 | 2 | 0 |
4267 | 4267 | 2020-03-18 | Lancaster | South Carolina | 45057 | 2 | 0 |
4986 | 4986 | 2020-03-19 | Lancaster | Pennsylvania | 42071 | 2 | 0 |
5011 | 5011 | 2020-03-19 | Lancaster | South Carolina | 45057 | 3 | 0 |
5663 | 5663 | 2020-03-20 | Lancaster | Nebraska | 31109 | 1 | 0 |
5858 | 5858 | 2020-03-20 | Lancaster | Pennsylvania | 42071 | 2 | 0 |
5889 | 5889 | 2020-03-20 | Lancaster | South Carolina | 45057 | 3 | 0 |
6655 | 6655 | 2020-03-21 | Lancaster | Nebraska | 31109 | 2 | 0 |
6861 | 6861 | 2020-03-21 | Lancaster | Pennsylvania | 42071 | 4 | 0 |
6897 | 6897 | 2020-03-21 | Lancaster | South Carolina | 45057 | 3 | 0 |
7745 | 7745 | 2020-03-22 | Lancaster | Nebraska | 31109 | 2 | 0 |
7979 | 7979 | 2020-03-22 | Lancaster | Pennsylvania | 42071 | 5 | 0 |
8018 | 8018 | 2020-03-22 | Lancaster | South Carolina | 45057 | 5 | 0 |
8938 | 8938 | 2020-03-23 | Lancaster | Nebraska | 31109 | 2 | 0 |
9190 | 9190 | 2020-03-23 | Lancaster | Pennsylvania | 42071 | 5 | 0 |
9231 | 9231 | 2020-03-23 | Lancaster | South Carolina | 45057 | 7 | 0 |
10241 | 10241 | 2020-03-24 | Lancaster | Nebraska | 31109 | 3 | 0 |
10514 | 10514 | 2020-03-24 | Lancaster | Pennsylvania | 42071 | 10 | 0 |
10557 | 10557 | 2020-03-24 | Lancaster | South Carolina | 45057 | 7 | 0 |
11672 | 11672 | 2020-03-25 | Lancaster | Nebraska | 31109 | 3 | 0 |
11977 | 11977 | 2020-03-25 | Lancaster | Pennsylvania | 42071 | 12 | 0 |
12028 | 12028 | 2020-03-25 | Lancaster | South Carolina | 45057 | 7 | 0 |
13275 | 13275 | 2020-03-26 | Lancaster | Nebraska | 31109 | 3 | 0 |
13598 | 13598 | 2020-03-26 | Lancaster | Pennsylvania | 42071 | 21 | 0 |
13650 | 13650 | 2020-03-26 | Lancaster | South Carolina | 45057 | 7 | 0 |
15007 | 15007 | 2020-03-27 | Lancaster | Nebraska | 31109 | 4 | 0 |
15344 | 15344 | 2020-03-27 | Lancaster | Pennsylvania | 42071 | 33 | 0 |
15397 | 15397 | 2020-03-27 | Lancaster | South Carolina | 45057 | 8 | 0 |
16834 | 16834 | 2020-03-28 | Lancaster | Nebraska | 31109 | 4 | 0 |
17194 | 17194 | 2020-03-28 | Lancaster | Pennsylvania | 42071 | 45 | 1 |
17251 | 17251 | 2020-03-28 | Lancaster | South Carolina | 45057 | 9 | 0 |
17532 | 17532 | 2020-03-28 | Lancaster | Virginia | 51103 | 1 | 0 |
18757 | 18757 | 2020-03-29 | Lancaster | Nebraska | 31109 | 6 | 0 |
19132 | 19132 | 2020-03-29 | Lancaster | Pennsylvania | 42071 | 67 | 2 |
19191 | 19191 | 2020-03-29 | Lancaster | South Carolina | 45057 | 13 | 0 |
19493 | 19493 | 2020-03-29 | Lancaster | Virginia | 51103 | 1 | 0 |
20793 | 20793 | 2020-03-30 | Lancaster | Nebraska | 31109 | 8 | 0 |
21182 | 21182 | 2020-03-30 | Lancaster | Pennsylvania | 42071 | 97 | 2 |
21243 | 21243 | 2020-03-30 | Lancaster | South Carolina | 45057 | 14 | 0 |
21558 | 21558 | 2020-03-30 | Lancaster | Virginia | 51103 | 1 | 0 |
22917 | 22917 | 2020-03-31 | Lancaster | Nebraska | 31109 | 8 | 0 |
23318 | 23318 | 2020-03-31 | Lancaster | Pennsylvania | 42071 | 123 | 3 |
23381 | 23381 | 2020-03-31 | Lancaster | South Carolina | 45057 | 15 | 0 |
23704 | 23704 | 2020-03-31 | Lancaster | Virginia | 51103 | 1 | 0 |
25107 | 25107 | 2020-04-01 | Lancaster | Nebraska | 31109 | 9 | 0 |
25516 | 25516 | 2020-04-01 | Lancaster | Pennsylvania | 42071 | 157 | 3 |
25579 | 25579 | 2020-04-01 | Lancaster | South Carolina | 45057 | 17 | 0 |
25920 | 25920 | 2020-04-01 | Lancaster | Virginia | 51103 | 1 | 0 |
27366 | 27366 | 2020-04-02 | Lancaster | Nebraska | 31109 | 12 | 0 |
27789 | 27789 | 2020-04-02 | Lancaster | Pennsylvania | 42071 | 203 | 4 |
27854 | 27854 | 2020-04-02 | Lancaster | South Carolina | 45057 | 26 | 0 |
28210 | 28210 | 2020-04-02 | Lancaster | Virginia | 51103 | 1 | 0 |
29689 | 29689 | 2020-04-03 | Lancaster | Nebraska | 31109 | 14 | 0 |
30123 | 30123 | 2020-04-03 | Lancaster | Pennsylvania | 42071 | 232 | 5 |
30189 | 30189 | 2020-04-03 | Lancaster | South Carolina | 45057 | 31 | 0 |
30556 | 30556 | 2020-04-03 | Lancaster | Virginia | 51103 | 1 | 0 |
32072 | 32072 | 2020-04-04 | Lancaster | Nebraska | 31109 | 18 | 0 |
32513 | 32513 | 2020-04-04 | Lancaster | Pennsylvania | 42071 | 291 | 5 |
32580 | 32580 | 2020-04-04 | Lancaster | South Carolina | 45057 | 39 | 0 |
32955 | 32955 | 2020-04-04 | Lancaster | Virginia | 51103 | 1 | 0 |
34501 | 34501 | 2020-04-05 | Lancaster | Nebraska | 31109 | 18 | 0 |
34949 | 34949 | 2020-04-05 | Lancaster | Pennsylvania | 42071 | 371 | 8 |
35016 | 35016 | 2020-04-05 | Lancaster | South Carolina | 45057 | 41 | 0 |
35393 | 35393 | 2020-04-05 | Lancaster | Virginia | 51103 | 1 | 0 |
36970 | 36970 | 2020-04-06 | Lancaster | Nebraska | 31109 | 31 | 0 |
37424 | 37424 | 2020-04-06 | Lancaster | Pennsylvania | 42071 | 408 | 11 |
37491 | 37491 | 2020-04-06 | Lancaster | South Carolina | 45057 | 43 | 0 |
37876 | 37876 | 2020-04-06 | Lancaster | Virginia | 51103 | 1 | 0 |
39486 | 39486 | 2020-04-07 | Lancaster | Nebraska | 31109 | 34 | 0 |
39947 | 39947 | 2020-04-07 | Lancaster | Pennsylvania | 42071 | 490 | 14 |
40014 | 40014 | 2020-04-07 | Lancaster | South Carolina | 45057 | 46 | 0 |
40409 | 40409 | 2020-04-07 | Lancaster | Virginia | 51103 | 1 | 0 |
42042 | 42042 | 2020-04-08 | Lancaster | Nebraska | 31109 | 39 | 1 |
42507 | 42507 | 2020-04-08 | Lancaster | Pennsylvania | 42071 | 561 | 16 |
42574 | 42574 | 2020-04-08 | Lancaster | South Carolina | 45057 | 48 | 0 |
42978 | 42978 | 2020-04-08 | Lancaster | Virginia | 51103 | 1 | 0 |
44623 | 44623 | 2020-04-09 | Lancaster | Nebraska | 31109 | 44 | 1 |
45093 | 45093 | 2020-04-09 | Lancaster | Pennsylvania | 42071 | 596 | 17 |
45160 | 45160 | 2020-04-09 | Lancaster | South Carolina | 45057 | 51 | 0 |
45573 | 45573 | 2020-04-09 | Lancaster | Virginia | 51103 | 1 | 0 |
47235 | 47235 | 2020-04-10 | Lancaster | Nebraska | 31109 | 49 | 1 |
47710 | 47710 | 2020-04-10 | Lancaster | Pennsylvania | 42071 | 648 | 21 |
47777 | 47777 | 2020-04-10 | Lancaster | South Carolina | 45057 | 61 | 0 |
48199 | 48199 | 2020-04-10 | Lancaster | Virginia | 51103 | 1 | 0 |
49885 | 49885 | 2020-04-11 | Lancaster | Nebraska | 31109 | 50 | 1 |
50367 | 50367 | 2020-04-11 | Lancaster | Pennsylvania | 42071 | 698 | 23 |
50434 | 50434 | 2020-04-11 | Lancaster | South Carolina | 45057 | 62 | 0 |
50857 | 50857 | 2020-04-11 | Lancaster | Virginia | 51103 | 1 | 0 |
52559 | 52559 | 2020-04-12 | Lancaster | Nebraska | 31109 | 54 | 1 |
53040 | 53040 | 2020-04-12 | Lancaster | Pennsylvania | 42071 | 772 | 24 |
53107 | 53107 | 2020-04-12 | Lancaster | South Carolina | 45057 | 65 | 0 |
53532 | 53532 | 2020-04-12 | Lancaster | Virginia | 51103 | 1 | 0 |
55240 | 55240 | 2020-04-13 | Lancaster | Nebraska | 31109 | 57 | 1 |
55725 | 55725 | 2020-04-13 | Lancaster | Pennsylvania | 42071 | 828 | 24 |
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);