cities are listed in states table for USA

[jawandsingh]

below are cities not states
(3923, 'Byram', 231),
(3925, 'Cokato', 231),
(3940, 'Lowa', 231),
(3944, 'Medfield', 231),
(3964, 'Ramey', 231),
(3968, 'Sublimity', 231),
(3971, 'Trimble', 231),

this one is a repeated state name with misspell
(3954, 'New Jersy', 231),
this is state of Canada
(3961, 'Ontario', 231),

[javydreamercsw]

Any idea where those cities are from?

[javydreamercsw]

Trying to fix this on PR #46

[jawandsingh]

ok cool,

below are cities not states
(3923, 'Byram', 231),
(3925, 'Cokato', 231),
(3940, 'Lowa', 231),
(3944, 'Medfield', 231),
(3964, 'Ramey', 231),
(3968, 'Sublimity', 231),
(3971, 'Trimble', 231),

So, these records are listed in States.sql But these are actually cities. So, these must be in CIties.sql

P.S.:- I don't know which state these cities belong. As the data, I needed for my application was (Countries and States)

this one is a repeated state name with misspell
(3954, 'New Jersy', 231),

This record in States.sql is repeated one and it is misspelled.

this is state of Canada
(3961, 'Ontario', 231),

and this is actually a Canada State, Not USA State. So, This needs fix.

I hope this helps you to fix and merge in PR #46

[javydreamercsw]

I fixed Ontario and New Jersey and deleted the other cities. Will be added when someone provides the right data.

[jawandsingh]

well, I am closing this issue. Thanks for fixing it.

[javydreamercsw]

Keep in mind those won't show up until the PR is merged.