names

24 rows where place_id = 591243

✎ 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
3603833 1868871 1868871 defendant Attefeld alias Rypley John husbandman 591243 591243 Attefeld alias Rypley, John, of Worplesdon, husbandman 2
3752947 1942851 1942851 defendant Wylde Richard husbandman 591243 591243 Wylde, Richard, of Worplesdon, husbandman 0
3880684 1983805 1983805 defendant Weele Thomas clerk 591243 591243 Weele, Thomas, of Worplesdon, clerk 0
4041849 2039566 2039566 defendant Ockley Robert yeoman 591243 591243 Ockley, Robert, of Worplesdon, yeoman 0
4563032 2220003 2220003 defendant Bone Richard   591243 591243 Bone, Richard, of Worplesdon 1
4600170 2231279 2231279 plaintiff Thecchere Richard   591243 591243 Thecchere, Richard, of Worplesdon 0
4603555 2232296 2232296 defendant Courtmyll Richard   591243 591243 Courtmyll, Richard, of Worplesdon 0
4603557 2232297 2232297 defendant Courtmyll Richard   591243 591243 Courtmyll, Richard, of Worplesdon 0
4603562 2232299 2232299 defendant Courtmyll Richard   591243 591243 Courtmyll, Richard, of Worplesdon 0
4790949 2293261 2293261 defendant Lytewyn Paul gent 591243 591243 Lytewyn, Paul, of Worplesdon, gent 0
4790950 2293261 2293261 defendant Rauns Thomas yeoman 591243 591243 Rauns, Thomas, of Worplesdon, yeoman 1
4801298 2296595 2296595 defendant Letewyne Paul gent 591243 591243 Letewyne, Paul, of Worplesdon, gent 0
4915936 2331481 2331481 defendant Lymer John laborer 591243 591243 Lymer, John, of Worplesdon, laborer 0
4915938 2331481 2331481 defendant Manery John yeoman 591243 591243 Manery, John, of Worplesdon, yeoman 2
5036304 2367469 2367469 defendant Dabron Thomas husbandman 591243 591243 Dabron, Thomas, of Worplesdon, husbandman 0
5036305 2367469 2367469 defendant Colyer William husbandman 591243 591243 Colyer, William, of Worplesdon, husbandman 1
5273207 2437233 2437233 defendant Taillour William husbandman 591243 591243 Taillour, William, of Worplesdon, husbandman 3
5273235 2437239 2437239 defendant Taillour William husbandman 591243 591243 Taillour, William, of Worplesdon, husbandman 3
5460948 2493225 2493225 plaintiff Manory Stephen   591243 591243 Manory, Stephen, of Worplesdon 1
5504006 2506167 2506167 defendant Clyfton John yeoman 591243 591243 Clyfton, John, of Worplesdon, yeoman 0
5518443 2510598 2510598 defendant Clyfton John yeoman 591243 591243 Clyfton, John, of Worplesdon, yeoman 0
5598281 2534350 2534350 defendant Exfold John husbandman 591243 591243 Exfold, John, of Worplesdon, husbandman 4
5636832 2555461 2555461 defendant Sted- William husbandman 591243 591243 Sted-, William, of Worplesdon, husbandman 1
5636835 2555462 2555462 defendant Stede William husbandman 591243 591243 Stede, William, of Worplesdon, husbandman 1

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