ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 975 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Tyrrell 14
- Alleghany 3
- Alexander 1
- Chatham 1
- Cherokee 1
- Greene 1
- Hoke 1
- Jones 1
- Macon 1
- Montgomery 1
- Pamlico 1
- Pasquotank 1
- Perquimans 1
- Person 1
- Vance 1
state 1
- North Carolina · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423415 | 2423415 | 2022-04-19 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2420158 | 2420158 | 2022-04-18 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2416903 | 2416903 | 2022-04-17 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2413647 | 2413647 | 2022-04-16 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2410391 | 2410391 | 2022-04-15 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2407135 | 2407135 | 2022-04-14 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2403879 | 2403879 | 2022-04-13 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2400624 | 2400624 | 2022-04-12 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2397369 | 2397369 | 2022-04-11 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2394114 | 2394114 | 2022-04-10 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2390858 | 2390858 | 2022-04-09 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2387602 | 2387602 | 2022-04-08 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2384347 | 2384347 | 2022-04-07 | Tyrrell | North Carolina | 37177 | 975 | 8 |
2381092 | 2381092 | 2022-04-06 | Tyrrell | North Carolina | 37177 | 975 | 8 |
1633388 | 1633388 | 2021-08-19 | Jones | North Carolina | 37103 | 975 | 29 |
1247049 | 1247049 | 2021-04-22 | Perquimans | North Carolina | 37143 | 975 | 9 |
1233992 | 1233992 | 2021-04-18 | Alleghany | North Carolina | 37005 | 975 | 5 |
1230744 | 1230744 | 2021-04-17 | Alleghany | North Carolina | 37005 | 975 | 5 |
1227496 | 1227496 | 2021-04-16 | Alleghany | North Carolina | 37005 | 975 | 5 |
1100918 | 1100918 | 2021-03-08 | Pamlico | North Carolina | 37137 | 975 | 10 |
799071 | 799071 | 2020-12-05 | Macon | North Carolina | 37113 | 975 | 9 |
795790 | 795790 | 2020-12-04 | Cherokee | North Carolina | 37039 | 975 | 15 |
776373 | 776373 | 2020-11-28 | Person | North Carolina | 37145 | 975 | 11 |
730931 | 730931 | 2020-11-14 | Pasquotank | North Carolina | 37139 | 975 | 35 |
691981 | 691981 | 2020-11-02 | Greene | North Carolina | 37079 | 975 | 13 |
688699 | 688699 | 2020-11-01 | Alexander | North Carolina | 37003 | 975 | 10 |
529894 | 529894 | 2020-09-13 | Hoke | North Carolina | 37093 | 975 | 13 |
526672 | 526672 | 2020-09-12 | Montgomery | North Carolina | 37123 | 975 | 23 |
526701 | 526701 | 2020-09-12 | Vance | North Carolina | 37181 | 975 | 43 |
298404 | 298404 | 2020-07-03 | Chatham | North Carolina | 37037 | 975 | 43 |
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);