names

50 rows where place_id = 594207

✎ 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
3615080 1872362 1872362 defendant A Wode John husbandman 594207 594207 A Wode, John, of Chaldewell, husbandman 0
3713814 1930619 1930619 plaintiff Mooke John   594207 594207 (Mooke, John, of Chaldewell 1
4564769 2220544 2220544 defendant Staunton William clerk 594207 594207 Staunton, William, of Chaldewell, clerk 0
4630536 2240462 2240462 defendant Couper John   594207 594207 Couper, John, of Chaldewell 1
4630547 2240467 2240467 defendant Basse John   594207 594207 together with Basse, John, of Chaldewell 1
4646267 2244981 2244981 defendant Clerk Richard   594207 594207 Clerk, Richard, of Chaldewell, son of William 1
4648268 2245556 2245556 defendant Basse John   594207 594207 Basse, John, of Chaldewell 0
4753879 2281592 2281592 defendant Courtebame John clerk 594207 594207 Courtebame, John, of Chaldewell, clerk 0
4753967 2281623 2281623 defendant Cou--game John clerk 594207 594207 Cou--game, John, of Chaldewell, clerk 0
4798565 2295730 2295730 defendant Gote or Gore Robert herder or laborer 594207 594207 Gote or Gore, Robert, of Chaldewell, herder or laborer 2
4881347 2321070 2321070 defendant Herde William herder 594207 594207 Herde, William, of Chaldewell, herder 2
5094020 2384650 2384650 defendant Devyll John husbandman 594207 594207 Devyll, John, of Chaldewell, husbandman 0
5128686 2394873 2394873 defendant Hobbe Lawrence laborer 594207 594207 Hobbe, Lawrence, of Chaldewell, laborer 5
5143805 2399323 2399323 defendant Sleper Thomas husbandman 594207 594207 Sleper, Thomas, of Chaldewell, husbandman 0
5147878 2400521 2400521 defendant Hobbe Lawrence laborer 594207 594207 Hobbe, Lawrence, of Chaldewell, laborer 5
5153101 2402047 2402047 defendant Dawe John husbandman 594207 594207 Dawe, John, of Chaldewell, husbandman 2
5174829 2408334 2408334 defendant Sleper John husbandman 594207 594207 Sleper, John, of Chaldewell, husbandman 0
5182847 2410734 2410734 defendant Payntour Thomas laborer 594207 594207 Payntour, Thomas, of Chaldewell, laborer 4
5182848 2410734 2410734 defendant Hobbe Lawrence laborer 594207 594207 Hobbe, Lawrence, of Chaldewell, laborer 5
5185459 2411493 2411493 defendant Hobbe Lawrence husbandman 594207 594207 Hobbe, Lawrence, of Chaldewell, husbandman 0
5226756 2423491 2423491 defendant Lorde William husbandman 594207 594207 Lorde, William, of Chaldewell, husbandman 0
5226758 2423492 2423492 defendant Lorde William husbandman 594207 594207 Lorde, William, of Chaldewell, husbandman 0
5300927 2445232 2445232 defendant Wreght William laborer 594207 594207 Wreght, William, of Chaldewell, laborer 2
5300934 2445233 2445233 defendant Streght William laborer 594207 594207 Streght, William, of Chaldewell, laborer 2
5363909 2464364 2464364 defendant Weston William smith 594207 594207 Weston, William, of Chaldewell, smith 0
5382027 2469917 2469917 defendant Warde Robert husbandman 594207 594207 Warde, Robert, of Chaldewell, husbandman 0
5382028 2469917 2469917 defendant Warde William husbandman 594207 594207 Warde, William, of chaldewell, husbandman 1
5386267 2471135 2471135 defendant Neweman Andrew husbandman 594207 594207 Neweman, Andrew, of Chaldewell, husbandman 0
5386286 2471140 2471140 defendant Neweman Andrew husbandman 594207 594207 Neweman, Andrew, of Chaldewell, husbandman 0
5390468 2472335 2472335 defendant Warde Richard husbandman 594207 594207 Warde, Richard, of Chaldewell, husbandman 0
5390469 2472335 2472335 defendant Warde William husbandman 594207 594207 Warde,William, of Chaldewell, husbandman 1
5392875 2473035 2473035 defendant Warde William husbandman 594207 594207 Warde, William, of Chaldewell, husbandman 0
5398528 2474640 2474640 defendant Neweman Andrew husbandman 594207 594207 Neweman, Andrew, of Chaldewell, husbandman 0
5403398 2476045 2476045 defendant Warde Richard hsubandman 594207 594207 Warde, Richard, of Chaldewell, hsubandman 0
5403399 2476045 2476045 defendant Warde William husbandman 594207 594207 Warde, William, of Chaldewell, husbandman 1
5433264 2484913 2484913 defendant Warde Richard husbandman 594207 594207 Warde, Richard, of Chaldewell, husbandman 0
5433265 2484913 2484913 defendant Warde William husbandman 594207 594207 Warde, William, of Chaldewell, husbandman 1
5433817 2485086 2485086 defendant Pydwyn John carpenter 594207 594207 Pydwyn, John, of Chaldewell, carpenter 0
5441039 2487230 2487230 defendant Pedwyn John   594207 594207 Pedwyn, John, of Chaldewell 0
5450010 2489892 2489892 defendant Ward William husbandman 594207 594207 Ward, William, of Chaldewell, husbandman 0
5450011 2489892 2489892 defendant Ward Richard husbandman 594207 594207 Ward, Richard, of Chaldewell, husbandman 1
5462170 2493580 2493580 defendant Ward William husbandman 594207 594207 Ward, William, of Chaldewell, husbandman 0
5465437 2494571 2494571 defendant Warde William husbandman 594207 594207 Warde, William, of Chaldewell, husbandman 2
5475470 2497662 2497662 defendant Houberd Thomas husbandman 594207 594207 Houberd, Thomas, of Chaldewell, husbandman 0
5475735 2497738 2497738 defendant Warde William husbandman 594207 594207 Warde, William, of Chaldewell, husbandman 0
5485129 2500473 2500473 defendant Warde William husbandman 594207 594207 Warde, William, of Chaldewell, husbandman 0
5485130 2500473 2500473 defendant Warde Richard husbandman 594207 594207 Warde, Richard, of Chaldewell, husbandman 1
5487047 2501023 2501023 defendant Hoberd Thomas husbandman 594207 594207 Hoberd, Thomas, of Chaldewell, husbandman 0
5539164 2516733 2516733 defendant Pycheley Thomas yeoman 594207 594207 Pycheley, Thomas, of Chaldewell, yeoman 1
5631369 2553813 2553813 defendant Quykke Thomas husbandman 594207 594207 Quykke, Thomas, of Chaldewell, 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);