names

41 rows where place_id = 587808

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592495 1865269 1865269 defendant Drewe Henry husbandman 587808 587808 Drewe, Henry, of Dypford, husbandman 0
3592496 1865269 1865269 defendant Lytylton John husbandman 587808 587808 Lytylton, John, of Dypford, husbandman 1
3592497 1865269 1865269 defendant Luysshe Henry husbandman 587808 587808 Luysshe, Henry, of Dypford, husbandman 2
3592498 1865269 1865269 defendant Cholyswyche Elias husbandman 587808 587808 Cholyswyche, Elias, of Dypford, husbandman 3
3592499 1865269 1865269 defendant Mychell Thomas husbandman 587808 587808 Mychell, Thomas, of Dypford, husbandman 4
3592500 1865269 1865269 defendant Parker John husbandman 587808 587808 Parker, John, of Dypford, husbandman 5
3601628 1868165 1868165 defendant Wallyng Richard butcher 587808 587808 Wallyng, Richard, of Dypford, butcher 0
3635485 1905895 1905895 defendant Knyght Gervase husbandman 587808 587808 Knyght, Gervase, of Dypford, husbandman 0
3734380 1936992 1936992 defendant Swadell Richard husbandman 587808 587808 Swadell, Richard, of Dypford, husbandman 0
3828489 1966784 1966784 defendant Bowryng Thomas husbandman 587808 587808 Bowryng, Thomas, of Dypford, husbandman 0
3828490 1966784 1966784 defendant Cholgyswyche Nichola widow 587808 587808 Cholgyswyche, Nichola, of Dypford, widow 1
3858343 1976269 1976269 defendant Martyn Richard husbandman 587808 587808 Martyn, Richard, of Dypford, husbandman 0
3858900 1976465 1976465 defendant Taylour John yeoman 587808 587808 Taylour, John, of Dypford, yeoman 0
3889215 1986630 1986630 defendant Swadyll Richard husbandman 587808 587808 Swadyll, Richard, of Dypford, husbandman 0
3903162 1991286 1991286 defendant Swadell alias Simons Richard husbandman 587808 587808 Swadell alias Simons, Richard, of Dypford, husbandman 0
3903163 1991286 1991286 defendant Harvye John husbandman 587808 587808 Harvye, John, of Dypford, husbandman 1
3915907 1995700 1995700 defendant Sparke Edmund carpenter 587808 587808 Sparke, Edmund, of Dypford, carpenter 3
4876478 2319609 2319609 defendant Laurens John husbandman 587808 587808 Laurens, John, of Dypford, husbandman 0
5318823 2450721 2450721 defendant Mathewe Thomas husbandman 587808 587808 Mathewe, Thomas, of Dypford, husbandman 0
5332987 2454933 2454933 defendant Boys John husbandman 587808 587808 Boys, John, of Dypford, husbandman 4
5350737 2460341 2460341 defendant Boys John husbandman 587808 587808 Boys, John, of Dypford, husbandman 0
5353968 2461305 2461305 defendant Drewe John husbandman 587808 587808 Drewe, John, of Dypford, husbandman 0
5353969 2461305 2461305 defendant Lovet Richard husbandman 587808 587808 Lovet, Richard, of Dypford, husbandman 1
5361514 2463622 2463622 defendant Morleyes Thomas   587808 587808 Morleyes, Thomas, of Dypford, franklin 0
5367985 2465612 2465612 defendant Wyllyng Richard butcher 587808 587808 Wyllyng, Richard, of Dypford, butcher 2
5384123 2470549 2470549 defendant Groby Joan widow 587808 587808 Groby, Joan, of Dypford, widow 1
5386909 2471319 2471319 defendant Harry John husbandman 587808 587808 Harry, John, of Dypford, husbandman 0
5395933 2473924 2473924 defendant Groby Joan widow 587808 587808 Groby, Joan, of Dypford, widow 1
5399357 2474888 2474888 defendant Harry John   587808 587808 Harry, John, of Dypford 0
5399359 2474889 2474889 defendant Harry John husbandman 587808 587808 Harry, John, of dypford, husbandman 0
5409182 2477715 2477715 defendant Groby Joan   587808 587808 Groby, Joan, of Dypford 1
5412346 2478637 2478637 defendant Harry John, sen husbandman 587808 587808 Harry, John, sen, of Dypford, husbandman 0
5448485 2489443 2489443 defendant Harry Vincent husbandman 587808 587808 Harry, Vincent, of Dypford, husbandman 0
5459238 2492667 2492667 defendant Lovet Richard husbandman 587808 587808 Lovet, Richard, of Dypford, husbandman 0
5469433 2495781 2495781 defendant Reynell William clerk 587808 587808 Reynell, William, of Dypford, clerk 1
5494130 2503148 2503148 defendant Wallyng Richard butcher 587808 587808 Wallyng, Richard, of Dypford, butcher 1
5508414 2507503 2507503 defendant Harry Vincent husbandman 587808 587808 Harry, Vincent, of Dypford, husbandman 0
5515607 2509724 2509724 defendant Harry Vincent husbandman 587808 587808 Harry, Vincent, of Dypford, husbandman 0
5515963 2509839 2509839 defendant Tryste William husbandman 587808 587808 Tryste, William, of Dypford, husbandman 0
5556585 2521877 2521877 defendant Martyn John husbandman 587808 587808 Martyn, John, of Dypford, husbandman 0
5556586 2521877 2521877 defendant Wylyam Martin husbandman 587808 587808 Wylyam, Martin, of Dypford, 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);