names

24 rows where place_id = 669239

✎ 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
3992329 2022023 2022023 defendant Cars alias Tyler Henry husbandman 669239 669239 Cars alias Tyler, Henry, of Pudelton, husbandman 0
4005229 2026650 2026650 defendant Cars alias Tyler Henry husbandman 669239 669239 Cars alias Tyler, Henry, of Pudelton, husbandman 0
4449067 2184651 2184651 defendant Gautrove Walter   669239 669239 Gautrove, Walter, of Pudelton 0
4559163 2218817 2218817 defendant Haynes Henry   669239 669239 Haynes, Henry, of Pudelton 2
4572873 2223056 2223056 defendant Strode John   669239 669239 Strode, John, of Pudelton 0
4574653 2223598 2223598 defendant Saundres John   669239 669239 Saundres, John, of Pudelton 0
4579092 2224943 2224943 defendant Frye Richard   669239 669239 Frye, Richard, of Pudelton 0
4659128 2248726 2248726 defendant Seman John yeoman 669239 669239 Seman, John, of Pudelton, yeoman 4
4672048 2256906 2256906 plaintiff Churchyll John   669239 669239 Churchyll, John, of Pudelton, vicar 0
4701138 2265763 2265763 defendant Costard John smith 669239 669239 Costard, John, of Pudelton, smith 0
4725428 2273249 2273249 plaintiff Fysshere Henry   669239 669239 Fysshere, Henry, of Pudelton 0
4784747 2291236 2291236 defendant Archour John baker 669239 669239 Archour, John, of Pudelton, baker 2
4950102 2341998 2341998 defendant Cammell John husbandman 669239 669239 Cammell, John, of Pudelton, husbandman 1
4974316 2349284 2349284 defendant Clare Thomas smith 669239 669239 Clare, Thomas, of Pudelton, smith 0
4994750 2355286 2355286 defendant Copney Robert chapman 669239 669239 Copney, Robert, of Pudelton, chapman 3
4998354 2356382 2356382 defendant Hauld William husbandman 669239 669239 Hauld, William, of Pudelton, husbandman 0
5063431 2375588 2375588 defendant Clare Thomas smith 669239 669239 Clare, Thomas, of Pudelton, smith 0
5077711 2379829 2379829 defendant Fysshere William husbandman 669239 669239 Fysshere, William, of Pudelton, husbandman 1
5127857 2394625 2394625 defendant Camerell John yeoman 669239 669239 Camerell, John, of Pudelton, yeoman 0
5146908 2400237 2400237 defendant Camell John yeoman 669239 669239 Camell, John, of Pudelton, yeoman 0
5166816 2406021 2406021 defendant Camell John yeoman 669239 669239 Camell, John, of Pudelton, yeoman 0
5181897 2410453 2410453 defendant Caumell John yeoman 669239 669239 Caumell, John, of Pudelton, yeoman 0
5616220 2548867 2548867 defendant Bernard Walter   669239 669239 Bernard, Walter, of Pudelton 0
5616221 2548867 2548867 defendant Wodeman Walter   669239 669239 Wodeman, Walter, of Pudelton 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);