names

22 rows where place_id = 607299

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668562 1916124 1916124 defendant Lokwode William yeoman 607299 607299 Lokwode, William, of Sneterton, yeoman 0
3720045 1932542 1932542 defendant Galle Thomas yeoman 607299 607299 Galle, Thomas, of Sneterton, yeoman 1
3842435 1971169 1971169 defendant Gall Thomas yeoman 607299 607299 Gall, Thomas, of Sneterton, yeoman 0
4519797 2206548 2206548 defendant Steynfeld John   607299 607299 Steynfeld, John, of Sneterton 0
4537905 2212140 2212140 defendant Artays John   607299 607299 Artays, John, of Sneterton, parson 0
4657555 2248254 2248254 defendant Talyour Thomas husbandman 607299 607299 Talyour, Thomas, of Sneterton, husbandman 1
4692807 2263262 2263262 defendant Galle Thomas   607299 607299 Galle, Thomas, of Sneterton, parson of St Andrew's church 0
4955020 2343455 2343455 defendant Fuller Simon yeoman 607299 607299 Fuller, Simon, of Sneterton, yeoman 3
4981415 2351358 2351358 defendant Fuller Simon yeoman 607299 607299 Fuller, Simon, of Sneterton, yeoman 2
5027133 2364804 2364804 defendant Payne John gent 607299 607299 Payne, John, of Sneterton, gent 0
5037868 2367954 2367954 defendant Payn John gent 607299 607299 together with Payn, John, of Sneterton, gent 2
5055915 2373337 2373337 defendant Galle Thomas yeoman 607299 607299 Galle, Thomas, of Sneterton, yeoman 0
5055916 2373337 2373337 defendant Raynold William yeoman 607299 607299 Raynold, William, of Sneterton, yeoman 1
5070465 2377658 2377658 defendant Baxter Stephen husbandman 607299 607299 Baxter, Stephen, of Sneterton, husbandman 1
5338128 2456494 2456494 defendant Derhaute or Derhante Thomas husbandman 607299 607299 Derhaute or Derhante, Thomas, of Sneterton, husbandman 0
5338131 2456495 2456495 defendant Derhaute or Derhante Thomas husbandman 607299 607299 Derhaute or Derhante, Thomas, of Sneterton, husbandman 0
5350602 2460303 2460303 defendant Rage Peter yeoman 607299 607299 Rage, Peter, of Sneterton, yeoman 2
5350603 2460303 2460303 defendant Bromhall John yeoman 607299 607299 Bromhall, John, of Sneterton, yeoman 3
5350604 2460303 2460303 defendant Penvyre or Penbyre William laborer 607299 607299 Penvyre or Penbyre, William, of Sneterton, laborer 4
5586368 2530780 2530780 defendant Hauk or Hank Thomas husbandman 607299 607299 Hauk or Hank, Thomas, of Sneterton, husbandman 0
5592090 2532516 2532516 defendant Else John laborer 607299 607299 Else, John, of Sneterton, laborer 2
5592091 2532516 2532516 defendant Willymot William husbandman 607299 607299 Willymot, William, of Sneterton, husbandman 3

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