ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10,908 rows where county = "Greene" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- New York 774
- North Carolina 774
- Ohio 774
- Pennsylvania 774
- Tennessee 774
- Virginia 774
- Alabama 773
- Arkansas 773
- Georgia 773
- Indiana 773
- Missouri 773
- Mississippi 768
- Iowa 767
- Illinois 764
fips 14
county 1
- Greene · 10,808 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23003 | 23003 | 2020-03-31 | Greene | New York | 36039 | 16 | 0 |
23074 | 23074 | 2020-03-31 | Greene | North Carolina | 37079 | 3 | 0 |
23171 | 23171 | 2020-03-31 | Greene | Ohio | 39057 | 6 | 1 |
23313 | 23313 | 2020-03-31 | Greene | Pennsylvania | 42059 | 9 | 0 |
23452 | 23452 | 2020-03-31 | Greene | Tennessee | 47059 | 12 | 0 |
23690 | 23690 | 2020-03-31 | Greene | Virginia | 51079 | 1 | 0 |
23909 | 23909 | 2020-04-01 | Greene | Alabama | 1063 | 4 | 0 |
23987 | 23987 | 2020-04-01 | Greene | Arkansas | 5055 | 4 | 0 |
24253 | 24253 | 2020-04-01 | Greene | Georgia | 13133 | 8 | 0 |
24454 | 24454 | 2020-04-01 | Greene | Indiana | 18055 | 3 | 0 |
25027 | 25027 | 2020-04-01 | Greene | Missouri | 29077 | 51 | 6 |
25197 | 25197 | 2020-04-01 | Greene | New York | 36039 | 18 | 0 |
25268 | 25268 | 2020-04-01 | Greene | North Carolina | 37079 | 3 | 0 |
25366 | 25366 | 2020-04-01 | Greene | Ohio | 39057 | 8 | 1 |
25511 | 25511 | 2020-04-01 | Greene | Pennsylvania | 42059 | 9 | 0 |
25652 | 25652 | 2020-04-01 | Greene | Tennessee | 47059 | 15 | 1 |
25906 | 25906 | 2020-04-01 | Greene | Virginia | 51079 | 1 | 0 |
26131 | 26131 | 2020-04-02 | Greene | Alabama | 1063 | 4 | 0 |
26211 | 26211 | 2020-04-02 | Greene | Arkansas | 5055 | 4 | 0 |
26484 | 26484 | 2020-04-02 | Greene | Georgia | 13133 | 8 | 0 |
26693 | 26693 | 2020-04-02 | Greene | Indiana | 18055 | 8 | 0 |
27282 | 27282 | 2020-04-02 | Greene | Missouri | 29077 | 54 | 6 |
27457 | 27457 | 2020-04-02 | Greene | New York | 36039 | 21 | 0 |
27531 | 27531 | 2020-04-02 | Greene | North Carolina | 37079 | 4 | 0 |
27632 | 27632 | 2020-04-02 | Greene | Ohio | 39057 | 8 | 1 |
27784 | 27784 | 2020-04-02 | Greene | Pennsylvania | 42059 | 11 | 0 |
27930 | 27930 | 2020-04-02 | Greene | Tennessee | 47059 | 16 | 1 |
28196 | 28196 | 2020-04-02 | Greene | Virginia | 51079 | 1 | 0 |
28427 | 28427 | 2020-04-03 | Greene | Alabama | 1063 | 5 | 0 |
28508 | 28508 | 2020-04-03 | Greene | Arkansas | 5055 | 4 | 0 |
28788 | 28788 | 2020-04-03 | Greene | Georgia | 13133 | 12 | 0 |
29003 | 29003 | 2020-04-03 | Greene | Indiana | 18055 | 9 | 0 |
29602 | 29602 | 2020-04-03 | Greene | Missouri | 29077 | 60 | 7 |
29781 | 29781 | 2020-04-03 | Greene | New York | 36039 | 21 | 0 |
29857 | 29857 | 2020-04-03 | Greene | North Carolina | 37079 | 5 | 0 |
29961 | 29961 | 2020-04-03 | Greene | Ohio | 39057 | 9 | 1 |
30118 | 30118 | 2020-04-03 | Greene | Pennsylvania | 42059 | 11 | 0 |
30265 | 30265 | 2020-04-03 | Greene | Tennessee | 47059 | 16 | 1 |
30542 | 30542 | 2020-04-03 | Greene | Virginia | 51079 | 1 | 0 |
30784 | 30784 | 2020-04-04 | Greene | Alabama | 1063 | 5 | 0 |
30866 | 30866 | 2020-04-04 | Greene | Arkansas | 5055 | 4 | 0 |
31148 | 31148 | 2020-04-04 | Greene | Georgia | 13133 | 12 | 0 |
31369 | 31369 | 2020-04-04 | Greene | Indiana | 18055 | 9 | 0 |
31982 | 31982 | 2020-04-04 | Greene | Missouri | 29077 | 62 | 7 |
32167 | 32167 | 2020-04-04 | Greene | New York | 36039 | 27 | 0 |
32244 | 32244 | 2020-04-04 | Greene | North Carolina | 37079 | 6 | 0 |
32350 | 32350 | 2020-04-04 | Greene | Ohio | 39057 | 11 | 1 |
32508 | 32508 | 2020-04-04 | Greene | Pennsylvania | 42059 | 12 | 0 |
32656 | 32656 | 2020-04-04 | Greene | Tennessee | 47059 | 16 | 1 |
32941 | 32941 | 2020-04-04 | Greene | Virginia | 51079 | 2 | 0 |
33188 | 33188 | 2020-04-05 | Greene | Alabama | 1063 | 6 | 0 |
33270 | 33270 | 2020-04-05 | Greene | Arkansas | 5055 | 4 | 0 |
33555 | 33555 | 2020-04-05 | Greene | Georgia | 13133 | 12 | 0 |
33780 | 33780 | 2020-04-05 | Greene | Indiana | 18055 | 10 | 0 |
34410 | 34410 | 2020-04-05 | Greene | Missouri | 29077 | 61 | 7 |
34598 | 34598 | 2020-04-05 | Greene | New York | 36039 | 27 | 0 |
34675 | 34675 | 2020-04-05 | Greene | North Carolina | 37079 | 6 | 0 |
34783 | 34783 | 2020-04-05 | Greene | Ohio | 39057 | 13 | 1 |
34944 | 34944 | 2020-04-05 | Greene | Pennsylvania | 42059 | 12 | 0 |
35092 | 35092 | 2020-04-05 | Greene | Tennessee | 47059 | 17 | 1 |
35379 | 35379 | 2020-04-05 | Greene | Virginia | 51079 | 3 | 0 |
35627 | 35627 | 2020-04-06 | Greene | Alabama | 1063 | 8 | 0 |
35712 | 35712 | 2020-04-06 | Greene | Arkansas | 5055 | 4 | 0 |
36004 | 36004 | 2020-04-06 | Greene | Georgia | 13133 | 15 | 0 |
36233 | 36233 | 2020-04-06 | Greene | Indiana | 18055 | 11 | 0 |
36785 | 36785 | 2020-04-06 | Greene | Mississippi | 28041 | 1 | 0 |
36874 | 36874 | 2020-04-06 | Greene | Missouri | 29077 | 66 | 7 |
37068 | 37068 | 2020-04-06 | Greene | New York | 36039 | 27 | 0 |
37144 | 37144 | 2020-04-06 | Greene | North Carolina | 37079 | 8 | 0 |
37252 | 37252 | 2020-04-06 | Greene | Ohio | 39057 | 15 | 1 |
37419 | 37419 | 2020-04-06 | Greene | Pennsylvania | 42059 | 12 | 0 |
37568 | 37568 | 2020-04-06 | Greene | Tennessee | 47059 | 17 | 1 |
37862 | 37862 | 2020-04-06 | Greene | Virginia | 51079 | 4 | 0 |
38115 | 38115 | 2020-04-07 | Greene | Alabama | 1063 | 10 | 0 |
38201 | 38201 | 2020-04-07 | Greene | Arkansas | 5055 | 6 | 0 |
38496 | 38496 | 2020-04-07 | Greene | Georgia | 13133 | 23 | 1 |
38731 | 38731 | 2020-04-07 | Greene | Indiana | 18055 | 11 | 0 |
38821 | 38821 | 2020-04-07 | Greene | Iowa | 19073 | 1 | 0 |
39296 | 39296 | 2020-04-07 | Greene | Mississippi | 28041 | 1 | 0 |
39386 | 39386 | 2020-04-07 | Greene | Missouri | 29077 | 67 | 7 |
39583 | 39583 | 2020-04-07 | Greene | New York | 36039 | 24 | 0 |
39659 | 39659 | 2020-04-07 | Greene | North Carolina | 37079 | 10 | 0 |
39769 | 39769 | 2020-04-07 | Greene | Ohio | 39057 | 20 | 1 |
39941 | 39941 | 2020-04-07 | Greene | Pennsylvania | 42059 | 15 | 0 |
40091 | 40091 | 2020-04-07 | Greene | Tennessee | 47059 | 18 | 1 |
40395 | 40395 | 2020-04-07 | Greene | Virginia | 51079 | 4 | 0 |
40657 | 40657 | 2020-04-08 | Greene | Alabama | 1063 | 12 | 0 |
40744 | 40744 | 2020-04-08 | Greene | Arkansas | 5055 | 6 | 0 |
41040 | 41040 | 2020-04-08 | Greene | Georgia | 13133 | 23 | 1 |
41277 | 41277 | 2020-04-08 | Greene | Indiana | 18055 | 12 | 0 |
41367 | 41367 | 2020-04-08 | Greene | Iowa | 19073 | 1 | 0 |
41850 | 41850 | 2020-04-08 | Greene | Mississippi | 28041 | 1 | 0 |
41940 | 41940 | 2020-04-08 | Greene | Missouri | 29077 | 71 | 7 |
42140 | 42140 | 2020-04-08 | Greene | New York | 36039 | 25 | 0 |
42216 | 42216 | 2020-04-08 | Greene | North Carolina | 37079 | 10 | 0 |
42327 | 42327 | 2020-04-08 | Greene | Ohio | 39057 | 21 | 1 |
42501 | 42501 | 2020-04-08 | Greene | Pennsylvania | 42059 | 17 | 0 |
42653 | 42653 | 2020-04-08 | Greene | Tennessee | 47059 | 20 | 1 |
42964 | 42964 | 2020-04-08 | Greene | Virginia | 51079 | 4 | 0 |
43230 | 43230 | 2020-04-09 | Greene | Alabama | 1063 | 13 | 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);