Determine how to add states to Eunomia database for testing

[github-actions]

Currently, states are not present in the Eunomia database - it may be as simple a fix as to alter the location table and insert random state initials in the appropriate locations for each patient.

OMOPCDMCohortCreator.jl/test/sqlite/getters.jl

Line 7 in 92041e7

#= TODO: Determine how to add states to Eunomia database for testing

	@test ids == GetDatabasePersonIDs(sqlite_conn)
end

#= TODO: Determine how to add states to Eunomia database for testing 
Currently, states are not present in the Eunomia database - it may be as simple a fix as to alter the location table and insert random state initials in the appropriate locations for each patient.
labels: tests, moderate
=# 
# @testset "GetPatientState Tests" begin
# 
# end

[TheCedarPrince]

Might be useful to utilize Synthea as per this discussion: OHDSI/Eunomia#23

[fdefalco]

The Synthea generated data does in fact have State information however the current ETL-Synthea package does not load that data and so it is not available in the sample datasets. I think a solution would be to update ETL-Synthea to include this data and then create a new sample dataset or update the existing data sets in the EunomiaDatasets repository.

https://github.com/OHDSI/ETL-Synthea/blob/main/R/LoadEventTables.r