names

25 rows where place_id = 595425

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620442 1873972 1873972 defendant Beson John yeoman 595425 595425 Beson, John, of Estryngton, yeoman 10
3637410 1906506 1906506 defendant Benson John husbandman 595425 595425 Benson, John, of Estryngton, husbandman 0
4103923 2061679 2061679 defendant Aske George gent 595425 595425 Aske, George, of Estryngton, gent 2
4447759 2184228 2184228 plaintiff Faker Henry   595425 595425 Faker, Henry, of Estryngton 0
4655484 2247610 2247610 defendant Colle John   595425 595425 Colle, John, of Estryngton, wright 0
4708318 2267974 2267974 defendant Pedder John butcher 595425 595425 Pedder, John, of Estryngton, butcher 3
4710031 2268494 2268494 defendant Northby Richard husbandman 595425 595425 Northby, Richard, of Estryngton, husbandman 1
4721466 2272046 2272046 defendant Daweson Robert yeoman 595425 595425 Daweson, Robert, of Estryngton, yeoman 4
4738791 2277221 2277221 defendant Clerk Robert husbandman 595425 595425 Clerk, Robert, of Estryngton, husbandman 2
4777893 2289075 2289075 defendant Clerk Robert husbandman 595425 595425 Clerk, Robert, of Estryngton, husbandman 0
4873671 2318707 2318707 defendant Richardson Thomas husbandman 595425 595425 Richardson, Thomas, of Estryngton, husbandman 0
4994686 2355265 2355265 defendant Bailly William husbandman 595425 595425 Bailly, William, of Estryngton, husbandman 1
4994784 2355298 2355298 defendant Hedwyn William yeoman 595425 595425 Hedwyn, William, of Estryngton, yeoman 0
5001408 2357299 2357299 defendant Byrland John   595425 595425 Byrland, John, of Estryngton, mason 0
5058068 2373981 2373981 defendant Bedale John butcher 595425 595425 Bedale, John, of Estryngton, butcher 2
5077266 2379703 2379703 defendant Day Stephen husbandman 595425 595425 Day, Stephen, of Estryngton, husbandman 0
5091733 2383974 2383974 defendant Bland Thomas tailor 595425 595425 Bland, Thomas, of Estryngton, tailor 0
5119701 2392198 2392198 defendant Richardson Thomas husbandman 595425 595425 Richardson, Thomas, of Estryngton, husbandman 2
5350190 2460182 2460182 defendant Benwyk Richard laborer 595425 595425 Benwyk, Richard, of Estryngton, laborer 2
5383999 2470511 2470511 defendant Baynes Christopher husbandman 595425 595425 Baynes, Christopher, of Estryngton, husbandman 2
5466740 2494999 2494999 defendant Bayns Christopher husbandman 595425 595425 Bayns, Christopher, of Estryngton, husbandman 2
5473463 2497024 2497024 defendant Bayns Christopher husbandman 595425 595425 Bayns, Christopher, of Estryngton, husbandman 2
5509668 2507858 2507858 defendant Broun Richard cordwainer 595425 595425 Broun, Richard, of Estryngton, cordwainer 0
5511417 2508415 2508415 defendant Nature William weaver 595425 595425 Nature, William, of Estryngton, weaver 2
5603029 2535832 2535832 defendant Uty Thomas yeoman 595425 595425 Uty, Thomas, of Estryngton, yeoman 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);