names

38 rows where place_id = 607363

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668920 1916211 1916211 defendant Harvy Thomas husbandman 607363 607363 Harvy, Thomas, of Eversholt, husbandman 2
3676867 1918804 1918804 defendant Tylkek Edmund husbandman 607363 607363 Tylkek, Edmund, of Eversholt, husbandman 0
3846506 1972463 1972463 defendant Hogeson Thomas, junior laborer 607363 607363 Hogeson, Thomas, junior, of Eversholt, laborer 0
3913857 1994980 1994980 defendant Cowper Richard husbandman 607363 607363 Cowper, Richard, of Eversholt, husbandman 4
3923431 1998142 1998142 defendant Johnson Thomas yeoman 607363 607363 Johnson, Thomas, of Eversholt, yeoman 0
4020353 2032001 2032001 defendant Leache William laborer 607363 607363 Leache, William, of Eversholt, laborer 3
4292800 2127487 2127487 defendant Gybbes John husbandman 607363 607363 Gybbes, John, of Eversholt, husbandman 0
4292802 2127488 2127488 defendant Gybbes John husbandman 607363 607363 Gybbes, John, of Eversholt, husbandman 0
4714947 2270007 2270007 plaintiff Tymmes Richard   607363 607363 Tymmes, Richard, of Eversholt 0
4795814 2294842 2294842 defendant Webber John chapman 607363 607363 Webber, John, of Eversholt, chapman 0
4801538 2296662 2296662 defendant Rouberd Robert husbandman 607363 607363 Rouberd, Robert, of Eversholt, husbandman 0
4814713 2300716 2300716 defendant Rouberdes Robert yeoman 607363 607363 Rouberdes, Robert, of Eversholt, yeoman 0
4821336 2302753 2302753 defendant Dene John yeoman 607363 607363 Dene, John, of Eversholt, yeoman 0
4831508 2305887 2305887 defendant Draper Lawrence husbandman 607363 607363 Draper, Lawrence, of Eversholt, husbandman 0
4831513 2305889 2305889 defendant Draper Lawrence husbandman 607363 607363 Draper, Lawrence, of Eversholt, husbandman 0
4853579 2312535 2312535 defendant Bern Thomas husbandman 607363 607363 Bern, Thomas, of Eversholt, husbandman 1
4870658 2317801 2317801 defendant Clerk John husbandman 607363 607363 Clerk, John, of Eversholt, husbandman 0
4911492 2330096 2330096 defendant Tukke Thomas butcher 607363 607363 Tukke, Thomas, of Eversholt, butcher 0
4925916 2334535 2334535 defendant Felmersham William husbandman 607363 607363 Felmersham, William, of Eversholt, husbandman 2
5012017 2360366 2360366 plaintiff Wyggeston alias Gamell Richard clerk 607363 607363 Wyggeston alias Gamell, Richard, of Eversholt, clerk 0
5042980 2369516 2369516 defendant Wodward John yeoman 607363 607363 Wodward, John, of Eversholt, yeoman 1
5042985 2369517 2369517 defendant Ive Richard husbandman 607363 607363 Ive, Richard, of Eversholt, husbandman 2
5099748 2386362 2386362 defendant Porter John, senior baker 607363 607363 Porter, John, senior, of Eversholt, baker 0
5107606 2388657 2388657 defendant Tymmes John husbandman 607363 607363 Tymmes, John, of Eversholt, husbandman 0
5165995 2405797 2405797 defendant Hynton Thomas skinner 607363 607363 Hynton, Thomas, of Eversholt, skinner 1
5165999 2405797 2405797 defendant Elmesham Richard husbandman 607363 607363 Elmesham, Richard, of Eversholt, husbandman 5
5180743 2410108 2410108 defendant Hynton Thomas skinner 607363 607363 Hynton, Thomas, of Eversholt, skinner 1
5180747 2410108 2410108 defendant Felmesham Richard husbandman 607363 607363 Felmesham, Richard, of Eversholt, husbandman 5
5180750 2410109 2410109 defendant Hynton Thomas skinner 607363 607363 Hynton, Thomas, of Eversholt, skinner 1
5180754 2410109 2410109 defendant Felmersham Richard husbandman 607363 607363 Felmersham, Richard, of Eversholt, husbandman 5
5313795 2449154 2449154 plaintiff Bradwell Thomas   607363 607363 Bradwell, Thomas, of Eversholt 0
5329849 2453995 2453995 defendant Kyng Thomas husbandman 607363 607363 Kyng, Thomas, of Eversholt, husbandman 0
5346255 2458967 2458967 defendant Lodyngton Thomas   607363 607363 Lodyngton, Thomas, of Eversholt, mason 0
5348203 2459585 2459585 defendant Lokyn Richard husbandman 607363 607363 Lokyn, Richard, of Eversholt, husbandman 0
5348204 2459585 2459585 defendant Broun John husbandman 607363 607363 Broun, John, of Eversholt, husbandman 1
5409951 2477947 2477947 plaintiff Bradwell Thomas gent 607363 607363 Bradwell, Thomas, of Eversholt, gent 0
5490715 2502115 2502115 plaintiff Bradwell Thomas gent 607363 607363 Bradwell, Thomas, of Eversholt, gent 0
5505586 2506668 2506668 plaintiff Bradwell Thomas gent 607363 607363 Bradwell, Thomas, of Eversholt, gent 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);