names

43 rows where place_id = 588156

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593533 1865611 1865611 plaintiff Hille Andrew yeoman 588156 588156 Hille, Andrew, of Kympton, yeoman 0
3598899 1867281 1867281 defendant Sibly Joan widow 588156 588156 Sibly, Joan, of Kympton, widow 4
3632970 1905129 1905129 defendant Essam Fremund laborer 588156 588156 Essam, Fremund, of Kympton, laborer 0
3668976 1916228 1916228 defendant Myllys John pardoner 588156 588156 Myllys, John, of Kympton, pardoner 4
3673384 1917695 1917695 defendant Pede John husbandman 588156 588156 Pede, John, of Kympton, husbandman 0
3703006 1927214 1927214 defendant Pede John husbandman 588156 588156 Pede, John, of Kympton, husbandman 0
3758074 1944509 1944509 defendant Penyffather John husbandman 588156 588156 Penyffather, John, of Kympton, husbandman 4
3766653 1947232 1947232 defendant Regwey Henry miller 588156 588156 Regwey, Henry, of Kympton, miller 0
3843117 1971371 1971371 defendant Feld Thomas husbandman 588156 588156 (Feld, Thomas, of Kympton, husbandman 1
3878998 1983226 1983226 defendant Hynde Thomas yeoman 588156 588156 Hynde, Thomas, of Kympton, yeoman 0
3910584 1993853 1993853 defendant Pede John husbandman 588156 588156 Pede, John, of Kympton, husbandman 0
3928893 2000002 2000002 plaintiff alwye John husbandman 588156 588156 alwye, John, of Kympton, husbandman 1
3930104 2000415 2000415 defendant Noyes Robert husbandman 588156 588156 Noyes, Robert, of Kympton, husbandman 0
3930105 2000415 2000415 defendant Noyes John husbandman 588156 588156 Noyes, John, of Kympton, husbandman 1
4165142 2083317 2083317 defendant Gamble Richard yeoman 588156 588156 Gamble, Richard, of Kympton, yeoman 0
4171828 2085606 2085606 defendant Peade Edward husbandman 588156 588156 Peade, Edward, of Kympton, husbandman 0
4501666 2201123 2201123 defendant Terrence Thomas   588156 588156 Terrence, Thomas, of Kympton 1
4547809 2215256 2215256 plaintiff Carter Thomas (legal representative) 588156 588156 Carter, Thomas, of Kympton, vicar, executors of 0
4547810 2215256 2215256 plaintiff Baker John chaplain 588156 588156 (Baker, John, of Kympton, chaplain 1
4649599 2245915 2245915 defendant Leget Edward   588156 588156 Leget, Edward, of Kympton 2
4690977 2262702 2262702 defendant Sibily Richard colyer 588156 588156 Sibily, Richard, of Kympton, colyer 0
4727084 2273732 2273732 defendant Saundrys John clerk 588156 588156 Saundrys, John, of Kympton, clerk 0
4830195 2305486 2305486 defendant Legat Edward husbandman 588156 588156 Legat, Edward, of Kympton, husbandman 0
4830203 2305487 2305487 defendant Legat Edward husbandman 588156 588156 Legat, Edward, of Kympton, husbandman 0
4972582 2348730 2348730 plaintiff Kympton John gent 588156 588156 Kympton, John, of Kympton, gent 0
4972583 2348730 2348730 defendant Kympton John   588156 588156 Kympton, John, of Kympton, or of London, vintner, executorsof 0
5040213 2368672 2368672 defendant Chave William   588156 588156 Chave, William, of Kympton, wheel wright 0
5106249 2388265 2388265 defendant Cattelyn William husbandman 588156 588156 (Cattelyn, William, of Kympton, husbandman 1
5240052 2427291 2427291 defendant Pede John husbandman 588156 588156 Pede, John, of Kympton, husbandman 2
5301869 2445514 2445514 defendant Catelyn William husbandman 588156 588156 Catelyn, William, of Kympton, husbandman 2
5301870 2445514 2445514 defendant Catelyn Thomas husbandman 588156 588156 Catelyn, Thomas, of Kympton, husbandman 3
5309115 2447763 2447763 defendant Catelyn Thomas husbandman 588156 588156 Catelyn, Thomas, of Kympton, husbandman 0
5309117 2447764 2447764 defendant Catelyn Thomas husbandman 588156 588156 Catelyn, Thomas, of Kympton, husbandman 0
5309118 2447764 2447764 defendant Catelyn John husbandman 588156 588156 Catelyn, John, of Kympton, husbandman 1
5340356 2457189 2457189 defendant Cooke William smith 588156 588156 Cooke, William, of Kympton, smith 0
5389421 2472020 2472020 defendant Byrte Thomas   588156 588156 Byrte, Thomas, of Kympton, book binder 0
5452387 2490586 2490586 defendant Catelyn Thomas husbandman 588156 588156 Catelyn, Thomas, of Kympton, husbandman 0
5471692 2496483 2496483 defendant Byrt Thomas   588156 588156 Byrt, Thomas, of Kympton, book binder 0
5519504 2510942 2510942 defendant Hewet Thomas husbandman 588156 588156 Hewet, Thomas, of Kympton, husbandman 0
5519505 2510942 2510942 defendant Amore John tailor 588156 588156 Amore, John, of Kympton, tailor 1
5519506 2510942 2510942 defendant Hyll John husbandman 588156 588156 Hyll, John, of Kympton, husbandman 2
5519507 2510942 2510942 defendant Hyll William laborer 588156 588156 Hyll, William, of Kympton, laborer 3
5629038 2553052 2553052 defendant atte Wode Thomas husbandman 588156 588156 atte Wode, Thomas, of Kympton, husbandman 0

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