names

16 rows where place_id = 794024

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4005316 2026680 2026680 defendant Grenewood James (legal representative) 794024 794024 Grenewood, James, of Haverburgh, Leics, gent, executor of 0
4738806 2277228 2277228 defendant Wermyngton John husbandman 794024 794024 Wermyngton, John, of Haverburgh, Leics, husbandman 0
4828125 2304839 2304839 defendant Boseworth Robert   794024 794024 Boseworth, Robert, of Haverburgh, Leics, single man 4
5111771 2389834 2389834 defendant Mosse William yeoman 794024 794024 Mosse, William, of Haverburgh, Leics, yeoman 7
5119892 2392252 2392252 defendant Stotysbury Margaret widow 794024 794024 Stotysbury, Margaret, of Haverburgh, Leics, widow 0
5215751 2420331 2420331 defendant Warmyngton John husbandman 794024 794024 Warmyngton, John, of Haverburgh, Leics, husbandman 4
5277522 2438503 2438503 defendant Lewete William butcher 794024 794024 Lewete, William, of Haverburgh, Leics, butcher 1
5280057 2439242 2439242 defendant Humfrey John mercer 794024 794024 Humfrey, John, of Haverburgh, Leics, mercer 0
5280059 2439243 2439243 defendant Humfrey John mercer 794024 794024 Humfrey, John, of Haverburgh, Leics, mercer 0
5287178 2441268 2441268 defendant Sherman Richad fuller 794024 794024 Sherman, Richad, of Haverburgh, Leics, fuller 0
5287180 2441269 2441269 defendant Sherman Richard fuller 794024 794024 Sherman, Richard, of Haverburgh, Leics, fuller 0
5407489 2477214 2477214 defendant Mershe John draper 794024 794024 Mershe, John, of Haverburgh, Leics, draper 0
5439636 2486796 2486796 defendant Mersshe John draper 794024 794024 Mersshe, John, of Haverburgh, Leics, draper 0
5488294 2501398 2501398 defendant Mershe John draper 794024 794024 Mershe, John, of Haverburgh, Leics, draper 0
5519908 2511064 2511064 defendant Mallory Simon esq 794024 794024 Mallory, Simon, of Haverburgh, Leics, esq 0
5571227 2526144 2526144 defendant Archer John mercer 794024 794024 Archer, John, of Haverburgh, Leics, mercer 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);