ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Monroe" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
80496 | 80496 | 2020-04-22 | Monroe | Pennsylvania | 42089 | 1015 | 48 |
77706 | 77706 | 2020-04-21 | Monroe | Pennsylvania | 42089 | 995 | 46 |
74924 | 74924 | 2020-04-20 | Monroe | Pennsylvania | 42089 | 970 | 39 |
72149 | 72149 | 2020-04-19 | Monroe | Pennsylvania | 42089 | 963 | 38 |
69382 | 69382 | 2020-04-18 | Monroe | Pennsylvania | 42089 | 943 | 34 |
66624 | 66624 | 2020-04-17 | Monroe | Pennsylvania | 42089 | 929 | 29 |
63878 | 63878 | 2020-04-16 | Monroe | Pennsylvania | 42089 | 898 | 29 |
61152 | 61152 | 2020-04-15 | Monroe | Pennsylvania | 42089 | 872 | 28 |
58437 | 58437 | 2020-04-14 | Monroe | Pennsylvania | 42089 | 847 | 27 |
55734 | 55734 | 2020-04-13 | Monroe | Pennsylvania | 42089 | 816 | 24 |
53049 | 53049 | 2020-04-12 | Monroe | Pennsylvania | 42089 | 795 | 23 |
50376 | 50376 | 2020-04-11 | Monroe | Pennsylvania | 42089 | 774 | 22 |
47719 | 47719 | 2020-04-10 | Monroe | Pennsylvania | 42089 | 752 | 19 |
45102 | 45102 | 2020-04-09 | Monroe | Pennsylvania | 42089 | 716 | 19 |
42516 | 42516 | 2020-04-08 | Monroe | Pennsylvania | 42089 | 671 | 17 |
39956 | 39956 | 2020-04-07 | Monroe | Pennsylvania | 42089 | 610 | 12 |
37433 | 37433 | 2020-04-06 | Monroe | Pennsylvania | 42089 | 572 | 11 |
34958 | 34958 | 2020-04-05 | Monroe | Pennsylvania | 42089 | 528 | 11 |
32522 | 32522 | 2020-04-04 | Monroe | Pennsylvania | 42089 | 484 | 11 |
30132 | 30132 | 2020-04-03 | Monroe | Pennsylvania | 42089 | 397 | 10 |
27798 | 27798 | 2020-04-02 | Monroe | Pennsylvania | 42089 | 321 | 10 |
25525 | 25525 | 2020-04-01 | Monroe | Pennsylvania | 42089 | 278 | 8 |
23327 | 23327 | 2020-03-31 | Monroe | Pennsylvania | 42089 | 236 | 7 |
21191 | 21191 | 2020-03-30 | Monroe | Pennsylvania | 42089 | 182 | 7 |
19141 | 19141 | 2020-03-29 | Monroe | Pennsylvania | 42089 | 135 | 3 |
17202 | 17202 | 2020-03-28 | Monroe | Pennsylvania | 42089 | 106 | 2 |
15351 | 15351 | 2020-03-27 | Monroe | Pennsylvania | 42089 | 98 | 2 |
13605 | 13605 | 2020-03-26 | Monroe | Pennsylvania | 42089 | 67 | 2 |
11984 | 11984 | 2020-03-25 | Monroe | Pennsylvania | 42089 | 51 | 1 |
10519 | 10519 | 2020-03-24 | Monroe | Pennsylvania | 42089 | 45 | 1 |
9195 | 9195 | 2020-03-23 | Monroe | Pennsylvania | 42089 | 43 | 1 |
7984 | 7984 | 2020-03-22 | Monroe | Pennsylvania | 42089 | 31 | 0 |
6865 | 6865 | 2020-03-21 | Monroe | Pennsylvania | 42089 | 25 | 0 |
5862 | 5862 | 2020-03-20 | Monroe | Pennsylvania | 42089 | 19 | 0 |
4990 | 4990 | 2020-03-19 | Monroe | Pennsylvania | 42089 | 15 | 0 |
4249 | 4249 | 2020-03-18 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3631 | 3631 | 2020-03-17 | Monroe | Pennsylvania | 42089 | 9 | 0 |
3101 | 3101 | 2020-03-16 | Monroe | Pennsylvania | 42089 | 9 | 0 |
2636 | 2636 | 2020-03-15 | Monroe | Pennsylvania | 42089 | 7 | 0 |
2214 | 2214 | 2020-03-14 | Monroe | Pennsylvania | 42089 | 3 | 0 |
1852 | 1852 | 2020-03-13 | Monroe | Pennsylvania | 42089 | 3 | 0 |
1554 | 1554 | 2020-03-12 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1310 | 1310 | 2020-03-11 | Monroe | Pennsylvania | 42089 | 2 | 0 |
1116 | 1116 | 2020-03-10 | Monroe | Pennsylvania | 42089 | 1 | 0 |
964 | 964 | 2020-03-09 | Monroe | Pennsylvania | 42089 | 1 | 0 |
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);