names

23 rows where place_id = 605632

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662375 1914144 1914144 defendant Tubman William yeoman 605632 605632 Tubman, William, of Asshton, yeoman 0
3695685 1924882 1924882 plaintiff Raynold John merchant 605632 605632 Raynold, John, of Asshton, merchant 0
3757310 1944266 1944266 defendant Wodeley John husbandman 605632 605632 Wodeley, John, of Asshton, husbandman 1
3757311 1944266 1944266 defendant Wylloughes William husbandman 605632 605632 Wylloughes, William, of Asshton, husbandman 2
3757312 1944266 1944266 defendant Saward John husbandman 605632 605632 Saward, John, of Asshton, husbandman 3
3757313 1944266 1944266 defendant Petytt John husbandman 605632 605632 Petytt, John, of Asshton, husbandman 4
3843045 1971352 1971352 defendant Webbe John husbandman 605632 605632 Webbe, John, of Asshton, husbandman 2
4175884 2087042 2087042 defendant Reynold James clothier 605632 605632 Reynold, James, of Asshton, clothier 0
4641062 2243476 2243476 defendant Coterell John   605632 605632 Coterell, John, of Asshton 0
4691034 2262720 2262720 defendant Everard William yeoman 605632 605632 Everard, William, of Asshton, yeoman 1
4695108 2263963 2263963 defendant Baldwyn Thomas husbandman 605632 605632 Baldwyn, Thomas, of Asshton, husbandman 1
4716742 2270558 2270558 defendant Everard William yeoman 605632 605632 Everard, William, of Asshton, yeoman 1
5046724 2370644 2370644 defendant Buktell Robert carpenter 605632 605632 Buktell, Robert, of Asshton, carpenter 0
5046725 2370644 2370644 defendant Keyser William husbandman 605632 605632 Keyser, William, of Asshton, husbandman 1
5283511 2440229 2440229 defendant Rowe Richard   605632 605632 Rowe, Richard, of Asshton, rough mason 0
5346915 2459194 2459194 defendant Ford John   605632 605632 Ford, John, of Asshton, parish clerk 1
5346916 2459194 2459194 defendant Hatter John butcher 605632 605632 Hatter, John, of Asshton, butcher 2
5414086 2479149 2479149 defendant Harrys Richard laborer 605632 605632 Harrys, Richard, of Asshton, laborer 2
5497106 2504072 2504072 defendant Philipp William husbandman 605632 605632 Philipp, William, of Asshton, husbandman 1
5505857 2506754 2506754 defendant Grene John husbandman 605632 605632 Grene, John, of Asshton, husbandman 1
5569096 2525512 2525512 defendant Potter John husbandman 605632 605632 Potter, John, of Asshton, husbandman 0
5569098 2525513 2525513 defendant Potter John husbandman 605632 605632 Potter, John, of Asshton, husbandman 0
5583896 2530042 2530042 defendant Potter John husbandman 605632 605632 Potter, John, of Asshton, husbandman 0

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);