Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[CSBS] New Jersey showing 0 deaths #241

Open
nguyandy opened this issue Mar 31, 2020 · 2 comments
Open

[CSBS] New Jersey showing 0 deaths #241

nguyandy opened this issue Mar 31, 2020 · 2 comments
Labels
help wanted Extra attention is needed question Further information is requested source: csbs

Comments

@nguyandy
Copy link

nguyandy commented Mar 31, 2020 •
edited
Loading

At the time of posting, it's at 198.

It looks like on CSBS - map (https://www.csbs.org/information-covid-19-coronavirus), the death is at 198. However, it's under the state "New Jersey", county "Unassigned"

Actually, it looks like the "Unassigned" numbers are no being included at all from the https://coronavirus-tracker-api.herokuapp.com/v2/locations?source=csbs endpoint. (ex, New York has an "Unassigned" count at 278 deaths.
@Kilo59
Copy link
Collaborator

Kilo59 commented Mar 31, 2020 •
edited
Loading

I'm not seeing any "Unassigned" county.
The next time you encounter this, it's helpful if you capture your exact HTTP request and response.
With httpie you can add the -v flag to your commands.

λ http GET https://coronavirus-tracker-api.herokuapp.com/v2/locations source==csbs province=="New Jersey" -v
GET /v2/locations?source=csbs&province=New+Jersey HTTP/1.1
Accept: */*
Accept-Encoding: gzip, deflate
Connection: keep-alive
Host: coronavirus-tracker-api.herokuapp.com
User-Agent: HTTPie/2.0.0



HTTP/1.1 200 OK
Connection: keep-alive
Content-Length: 5847
Content-Type: application/json
Date: Tue, 31 Mar 2020 21:58:01 GMT
Server: uvicorn
Via: 1.1 vegur
{
    "latest": {
        "confirmed": 15010,
        "deaths": 20,
        "recovered": 0
    },
    "locations": [
        {
            "coordinates": {
                "latitude": "40.95949149",
                "longitude": "-74.074442"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Bergen",
            "id": 56,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 2909,
                "deaths": 4,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.78779259",
                "longitude": "-74.24760059"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Essex",
            "id": 57,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1900,
                "deaths": 4,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.74034231",
                "longitude": "-74.07410970000002"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Hudson",
            "id": 58,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1606,
                "deaths": 2,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.69635",
                "longitude": "-74.26957"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Union",
            "id": 59,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1418,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.86034",
                "longitude": "-74.12374"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Passaic",
            "id": 60,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1294,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.57936",
                "longitude": "-74.50067"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Middlesex",
            "id": 61,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1277,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.2600411",
                "longitude": "-74.22194634"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Monmouth",
            "id": 62,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1140,
                "deaths": 2,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.90927434",
                "longitude": "-74.2969653"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Ocean",
            "id": 63,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 1022,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.86201902",
                "longitude": "-74.5442741"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Morris",
            "id": 64,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 841,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.49859",
                "longitude": "-74.52249"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Somerset",
            "id": 65,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 413,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.28331911",
                "longitude": "-74.70157374"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Mercer",
            "id": 66,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 268,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.94525",
                "longitude": "-75.11913"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Camden",
            "id": 67,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 228,
                "deaths": 3,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.07687",
                "longitude": "-74.85775"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Burlington",
            "id": 68,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 202,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "41.13934496",
                "longitude": "-74.69067762"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Sussex",
            "id": 69,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 132,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.71720107",
                "longitude": "-75.14164366"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Gloucester",
            "id": 70,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 114,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.56725317",
                "longitude": "-74.91217921"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Hunterdon",
            "id": 71,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 97,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "40.85732358",
                "longitude": "-74.997063"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Warren",
            "id": 72,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 76,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.4806564",
                "longitude": "-74.67264306"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Atlantic",
            "id": 73,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 31,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.37311491",
                "longitude": "-75.11061925"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Cumberland",
            "id": 74,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 18,
                "deaths": 1,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "38.93547",
                "longitude": "-74.92137"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Cape May",
            "id": 75,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 12,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        },
        {
            "coordinates": {
                "latitude": "39.57661332",
                "longitude": "-75.35810746"
            },
            "country": "US",
            "country_code": "US",
            "country_population": 310232863,
            "county": "Salem",
            "id": 76,
            "last_updated": "2020-03-31T16:52:00Z",
            "latest": {
                "confirmed": 12,
                "deaths": 0,
                "recovered": 0
            },
            "province": "New Jersey"
        }
    ]
}

@Kilo59 Kilo59 added question Further information is requested source: csbs labels Mar 31, 2020
@nguyandy
Copy link
Author

nguyandy commented Apr 1, 2020 •
edited
Loading

I'm not seeing any "Unassigned" county.
The next time you encounter this, it's helpful if you capture your exact HTTP request and response.

Sorry I wasn't clear. This is from CSBS.
image

and from 1point3acres (where CSBS is getting their data from) https://coronavirus.1point3acres.com/en
image

Because the "Unassigned" data isn't being accounted for, the states data is off/incomplete

With the current API, this is the numbers I get for New Jersey
image
Which is 15311, however the NJ total should be 18997.
If we had the numbers from "Unassigned", it would be
15311 + 3686 = 18997
172 + 95 = 267

I imagine this applies to all the states with "Unassigned" data.
Hope that makes more sense.

@Kilo59 Kilo59 added the help wanted Extra attention is needed label Apr 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
help wanted Extra attention is needed question Further information is requested source: csbs
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Kilo59 @nguyandy