names

29 rows where place_id = 641733

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3863557 1978005 1978005 defendant Rudde John yeoman 641733 641733 Rudde, John, of Wantynge, Berks, yeoman 0
4545633 2214557 2214557 defendant Welford John   641733 641733 Welford, John, of Wantynge, Berks, son of William 0
4671219 2256654 2256654 defendant Yernemouthe John shoemaker 641733 641733 Yernemouthe, John, of Wantynge, Berks, shoemaker 2
4672298 2256985 2256985 defendant Walkyngton John   641733 641733 Walkyngton, John, of Wantynge, Berks, vicar & master of the Hospital of St Edward the Confessor in Durham Cathedral, & prebend of Norton College 0
4792088 2293626 2293626 defendant Burmyll John husbandman 641733 641733 Burmyll, John, of Wantynge, Berks, husbandman 0
4862788 2315345 2315345 defendant Grenewey William chapman 641733 641733 Grenewey, William, of Wantynge, Berks, chapman 0
4911255 2330024 2330024 defendant Castell Ralph chapman 641733 641733 Castell, Ralph, of Wantynge, Berks, chapman 0
4928929 2335471 2335471 defendant Clotheman John weaver 641733 641733 Clotheman, John, of Wantynge, Berks, weaver 2
4960942 2345236 2345236 defendant Richard Mathew shoemaker 641733 641733 Richard, Mathew, of Wantynge, Berks, shoemaker 1
4967107 2347094 2347094 defendant Hikkes William husbandman 641733 641733 Hikkes, William, of Wantynge, Berks, husbandman 1
4981879 2351502 2351502 defendant Hikkes William butcher 641733 641733 Hikkes, William, of Wantynge, Berks, butcher 0
4985116 2352475 2352475 defendant Greneway Roger husbandman 641733 641733 Greneway, Roger, of Wantynge, Berks, husbandman 0
4985125 2352478 2352478 defendant Greneway William husbandman 641733 641733 Greneway, William, of Wantynge, Berks, husbandman 0
4985346 2352537 2352537 defendant Fyge Hugh miller 641733 641733 Fyge, Hugh, of Wantynge, Berks, miller 0
5067266 2376720 2376720 defendant Burd William   641733 641733 Burd, William, of Wantynge, Berks, gent, customs collector of Bristol 0
5092799 2384272 2384272 defendant Helier John fisher 641733 641733 Helier, John, of Wantynge, Berks, fisher 1
5102742 2387216 2387216 defendant Clynche John draper 641733 641733 Clynche, John, of Wantynge, Berks, draper 0
5144629 2399586 2399586 defendant Clence John chapman 641733 641733 Clence, John, of Wantynge, Berks, chapman 4
5222623 2422334 2422334 defendant Bray Robert merchant 641733 641733 Bray, Robert, of Wantynge, Berks, merchant 0
5235540 2425976 2425976 defendant Goylin John gent 641733 641733 Goylin, John, of Wantynge, Berks, gent 1
5286072 2440934 2440934 defendant Smyth Martin chapman 641733 641733 Smyth, Martin, of Wantynge, Berks, chapman 1
5286987 2441203 2441203 defendant Bedfod Robert kerseyman 641733 641733 Bedfod, Robert, of Wantynge, Berks, kerseyman 0
5295932 2443800 2443800 defendant Chapman alias Chilton William chapman 641733 641733 Chapman alias Chilton, William, of Wantynge, Berks, chapman 0
5295935 2443801 2443801 defendant Chapman alias Chylton William chapman 641733 641733 Chapman alias Chylton, William, of Wantynge, Berks, chapman 0
5313273 2449006 2449006 defendant Wyse Richard ostler 641733 641733 Wyse, Richard, of Wantynge, Berks, ostler 2
5330577 2454235 2454235 defendant Wyse Richard ostler 641733 641733 Wyse, Richard, of Wantynge, Berks, ostler 0
5333768 2455173 2455173 defendant Fynche Richard chapman 641733 641733 Fynche, Richard, of Wantynge, Berks, chapman 0
5518671 2510672 2510672 defendant Larke John husbandman 641733 641733 Larke, John, of Wantynge, Berks, husbandman 2
5625059 2551776 2551776 defendant Walkyngton John clerk 641733 641733 Walkyngton, John, of Wantynge, Berks, clerk 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);