names

20 rows where place_id = 609210

✎ 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
3677494 1919010 1919010 defendant Phylyppe Thomas husbandman 609210 609210 Phylyppe, Thomas, of Stotfold, Beds, husbandman 0
3741149 1939093 1939093 defendant Bygrave John husbandman 609210 609210 Bygrave, John, of Stotfold, Beds, husbandman 3
3811029 1961343 1961343 defendant Slough Thomas husbandman 609210 609210 Slough, Thomas, of Stotfold, Beds, husbandman 0
3906515 1992471 1992471 defendant Gayler George husbandman 609210 609210 Gayler, George, of Stotfold, Beds, husbandman 0
3911478 1994157 1994157 defendant Gayler George husbandman 609210 609210 Gayler, George, of Stotfold, Beds, husbandman 0
3941914 2004307 2004307 defendant Butler Edward esq 609210 609210 Butler, Edward, of Stotfold, Beds, esq 0
3946593 2005874 2005874 defendant Butler Edward (legal representative) 609210 609210 Butler, Edward, of Stotfold, Beds, gent, executrix of 0
3955299 2008921 2008921 defendant Butler Elizabeth widow 609210 609210 Butler, Elizabeth, of Stotfold, Beds, widow 1
3955301 2008922 2008922 defendant Butler Edward (legal representative) 609210 609210 Butler, Edward, of Stotfold, Beds, gent, executrix of 0
4170639 2085231 2085231 defendant Rotchford William husbandman 609210 609210 Rotchford, William, of Stotfold, Beds, husbandman 3
4373166 2155470 2155470 defendant Wyngate Edward gent 609210 609210 Wyngate, Edward, of Stotfold, Beds, gent 0
4408378 2167376 2167376 defendant Plomer William gent 609210 609210 Plomer, William, of Stotfold, Beds, gent 0
4851289 2311850 2311850 defendant May Thomas gent 609210 609210 May, Thomas, of Stotfold, Beds, gent 0
4883730 2321822 2321822 defendant Stotfold William esq 609210 609210 Stotfold, William, of Stotfold, Beds, esq 1
5051732 2372130 2372130 defendant Munne John, senior husbandman 609210 609210 Munne, John, senior, of Stotfold, Beds, husbandman 0
5318581 2450653 2450653 plaintiff Grene John, senior (legal representative) 609210 609210 Grene, John, senior, of Stotfold, Beds, gent, executors of 0
5387013 2471351 2471351 defendant Bendryche John smith 609210 609210 Bendryche, John, of Stotfold, Beds, smith 2
5387015 2471351 2471351 defendant Fadlet John husbandman 609210 609210 Fadlet, John, of Stotfold, Beds, husbandman 4
5399458 2474922 2474922 defendant Beteryche John smith 609210 609210 Beteryche, John, of Stotfold, Beds, smith 2
5412441 2478667 2478667 defendant Beveriche John smith 609210 609210 Beveriche, John, of Stotfold, Beds, smith 2

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