names

30 rows where place_id = 659596

✎ 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
3953097 2008149 2008149 defendant Myller Thomas husbandman 659596 659596 Myller, Thomas, of Barton Segrave, husbandman 0
4007273 2027382 2027382 defendant Johnson John husbandman 659596 659596 Johnson, John, of Barton Segrave, husbandman 0
4144056 2076085 2076085 defendant Humfry Thomas gent 659596 659596 Humfry, Thomas, of Barton Segrave, gent 0
4144057 2076085 2076085 defendant Parche Richard yeoman 659596 659596 Parche, Richard, of Barton Segrave, yeoman 1
4160814 2081858 2081858 defendant Humfrey Richard gent 659596 659596 Humfrey, Richard, of Barton Segrave, or of Greys Inn, Middx, gent 1
4442148 2182474 2182474 defendant Napton Thomas   659596 659596 Napton, Thomas, of Barton Segrave, parson 0
4501090 2200945 2200945 defendant Smyth Thomas   659596 659596 Smyth, Thomas, of Barton Segrave, parson of the church in Maydewell 0
4565237 2220700 2220700 defendant Milnere Simon   659596 659596 Milnere, Simon, of Barton Segrave 0
4617726 2236544 2236544 defendant Musgrave John   659596 659596 Musgrave, John, of Barton Segrave 0
4681426 2259811 2259811 defendant Coleyn William   659596 659596 Coleyn, William, of Barton Segrave, bailiff 2
4760137 2283516 2283516 defendant Wagge Richard yeoman 659596 659596 Wagge, Richard, of Barton Segrave, yeoman 0
4782725 2290612 2290612 defendant Wagge Richard yeoman 659596 659596 Wagge, Richard, of Barton Segrave, yeoman 0
4995962 2355641 2355641 defendant Sprot John husbandman 659596 659596 Sprot, John, of Barton Segrave, husbandman 2
4999180 2356626 2356626 defendant Squybbe William clerk 659596 659596 Squybbe, William, of Barton Segrave, clerk 0
5019603 2362622 2362622 defendant Stokebrigge John husbandman 659596 659596 Stokebrigge, John, of Barton Segrave, husbandman 1
5019604 2362622 2362622 defendant Michell John husbandman 659596 659596 Michell, John, of Barton Segrave, husbandman 2
5055294 2373169 2373169 defendant Draper Thomas husbandman 659596 659596 Draper, Thomas, of Barton Segrave, husbandman 0
5055295 2373169 2373169 defendant Myll John husbandman 659596 659596 Myll, John, of Barton Segrave, husbandman 1
5055296 2373169 2373169 defendant Lanwarch John husbandman 659596 659596 Lanwarch, John, of Barton Segrave, husbandman 2
5101718 2386925 2386925 defendant Kyng William husbandman 659596 659596 Kyng, William, of Barton Segrave, husbandman 1
5101721 2386926 2386926 defendant Kyng William husbandman 659596 659596 Kyng, William, of Barton Segrave, husbandman 1
5108989 2389047 2389047 defendant Stokbrygge William husbandman 659596 659596 Stokbrygge, William, of Barton Segrave, husbandman 1
5141280 2398572 2398572 plaintiff Umfrey John   659596 659596 Umfrey, John, of Barton Segrave 0
5312428 2448751 2448751 defendant Colles Henry husbandman 659596 659596 Colles, Henry, of Barton Segrave, husbandman 0
5358464 2462699 2462699 defendant Stone William clerk 659596 659596 Stone, William, of Barton Segrave, clerk 0
5361520 2463624 2463624 defendant Weldon John husbandman 659596 659596 Weldon, John, of Barton Segrave, husbandman 1
5383112 2470241 2470241 defendant Bounde Philip clerk 659596 659596 Bounde, Philip, of Barton Segrave, clerk 0
5521282 2511476 2511476 defendant Bond William clerk 659596 659596 Bond, William, of Barton Segrave, clerk 0
5531825 2514498 2514498 plaintiff Staunton William (legal representative) 659596 659596 Staunton, William, of Barton Segrave, executors of 0
5632748 2554256 2554256 defendant Teken Richard husbandman 659596 659596 Teken, Richard, of Barton Segrave, 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);