names

13 rows where case_id = 2346274

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4964428 2346274 2346274 plaintiff Clerk Thomas   586993 586993 Clerk, Thomas, of Wenlok 0
4964429 2346274 2346274 defendant Smyth John husbandman 828147 828147 Smyth, John, of Atyntham, husbandman 0
4964430 2346274 2346274 defendant Bromlowe William husbandman 773762 773762 Bromlowe, William, of Cundore, husbandman 1
4964431 2346274 2346274 defendant Alcokes John husbandman 773762 773762 Alcokes, John, of Cundore, husbandman 2
4964432 2346274 2346274 defendant Edwardes William husbandman 773762 773762 Edwardes, William, of Cundore, husbandman 3
4964433 2346274 2346274 defendant Philippes Roger husbandman 598479 598479 Philippes, Roger, of Acton Burnell, husbandman 4
4964434 2346274 2346274 defendant Harper John husbandman 828148 828148 Harper, John, of Cunley, husbandman 5
4964435 2346274 2346274 defendant Frensshe Richard husbandman 828149 828149 Frensshe, Richard, of Cattewall, husbandman 6
4964436 2346274 2346274 defendant Milleward Walter husbandman 587352 587352 Milleward, Walter, of Aston, husbandman 7
4964437 2346274 2346274 defendant Brook Nicholas husbandman 619652 619652 Brook, Nicholas, of Bruggenorth, husbandman 8
4964438 2346274 2346274 defendant Stevenes David husbandman 828150 828150 Stevenes, David, of Holt Prene, husbandman 9
4964439 2346274 2346274 defendant Stevenes Roger husbandman 828150 828150 Stevenes, Roger, of Holt Prene, husbandman 10
4964440 2346274 2346274 defendant Meghton Thomas husbandman 761519 761519 Meghton, Thomas, of Halghton, husbandman 11

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