names

41 rows where place_id = 595895

✎ 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
3622313 1874515 1874515 plaintiff Porter Richard   595895 595895 Porter, Richard, of Campden 0
3691999 1923663 1923663 defendant Porter Elizabeth widow 595895 595895 Porter, Elizabeth, of Campden, widow 0
3692584 1923866 1923866 defendant Porter Richard (legal representative) 595895 595895 Porter, Richard, of Campden, executrix of 0
3706289 1928254 1928254 defendant Porter Elizabeth widow 595895 595895 Porter, Elizabeth, of Campden, widow 0
3714736 1930909 1930909 defendant Porter Elizabeth widow 595895 595895 Porter, Elizabeth, of Campden, widow 1
3714739 1930910 1930910 defendant Porter Elizabeth widow 595895 595895 Porter, Elizabeth, of Campden, widow 1
3714752 1930916 1930916 defendant Porter Elizabeth widow 595895 595895 Porter, Elizabeth, of Campden, widow 1
3726556 1934563 1934563 defendant Aprice John glover 595895 595895 Aprice, John, of Campden, glover 1
3771569 1948806 1948806 defendant Hewstace John butcher 595895 595895 Hewstace, John, of Campden, butcher 0
3782513 1952274 1952274 defendant Saunders John butcher 595895 595895 Saunders, John, of Campden, butcher 2
3851289 1974002 1974002 defendant Pagett Roger baker 595895 595895 Pagett, Roger, of Campden, baker 0
3868562 1979724 1979724 defendant Jarret John clerk 595895 595895 Jarret, John, of Campden, clerk 4
3868563 1979724 1979724 defendant Bale William yeoman 595895 595895 Bale, William, of Campden, yeoman 5
3868564 1979724 1979724 defendant Herryn Roger yeoman 595895 595895 Herryn, Roger, of Campden, yeoman 6
3868565 1979724 1979724 defendant Bocher John yeoman 595895 595895 Bocher, John, of Campden, yeoman 7
3989288 2020910 2020910 plaintiff Ballard John smith 595895 595895 Ballard, John, of Campden, smith 0
3989289 2020910 2020910 defendant Bason Christopher   595895 595895 Bason, Christopher, of Campden, Glos currier 0
4065302 2047874 2047874 defendant Preston Richard yeoman 595895 595895 Preston, Richard, of Campden, yeoman 0
4065303 2047874 2047874 defendant Trothe Anthony yeoman 595895 595895 Trothe, Anthony, of Campden, yeoman 1
4108025 2063144 2063144 defendant Garratt Christopher yeoman 595895 595895 Garratt, Christopher, of Campden, yeoman 0
4202345 2096363 2096363 defendant Harryes John yeoman 595895 595895 Harryes, John, of Campden, yeoman 2
4617213 2236393 2236393 defendant Seynebury John barber 595895 595895 Seynebury, John, of Campden, barber 0
4637573 2242540 2242540 defendant Barbour John   595895 595895 Barbour, John, of Campden 0
4668023 2255708 2255708 defendant Merbery or Merkery William gent 595895 595895 Merbery or Merkery, William, of Campden, gent 1
4830108 2305458 2305458 defendant Burt John   595895 595895 Burt, John, of Campden, glove maker 4
4843047 2309359 2309359 defendant Welbek Richard merchant 595895 595895 Welbek, Richard, of Campden, merchant 4
5012243 2360431 2360431 plaintiff Wynger Richard   595895 595895 Wynger, Richard, of Campden 0
5025761 2364433 2364433 defendant Dyer Cecily widow 595895 595895 (Dyer, Cecily, of Campden, widow 1
5025762 2364433 2364433 defendant Bowyer Richard bowyer 595895 595895 Bowyer, Richard, of Campden, bowyer 2
5025763 2364433 2364433 defendant Baker John baker 595895 595895 Baker, John, of Campden, baker 3
5121625 2392750 2392750 defendant Hogyes Edmund husbandman 595895 595895 Hogyes, Edmund, of Campden, husbandman 4
5264425 2434629 2434629 defendant Chapman William cordwainer 595895 595895 Chapman, William, of Campden, cordwainer 3
5290829 2442326 2442326 defendant Bloundell John laborer 595895 595895 Bloundell, John, of Campden, laborer 0
5372653 2467045 2467045 defendant Belyvaunt Henry smith 595895 595895 Belyvaunt, Henry, of Campden, smith 0
5372654 2467045 2467045 defendant Smyth Hugh smith 595895 595895 Smyth, Hugh, of Campden, smith 1
5388339 2471711 2471711 defendant Smyth Hugh smith 595895 595895 Smyth, Hugh, of Campden, smith 4
5504186 2506224 2506224 defendant Waren John yeoman 595895 595895 Waren, John, of Campden, yeoman 0
5519567 2510956 2510956 defendant Bette John yeoman 595895 595895 Bette, John, of Campden, yeoman 0
5519950 2511079 2511079 plaintiff Bradwey William (legal representative) 595895 595895 Bradwey, William, of Campden, executors of 0
5533828 2515124 2515124 defendant Bonar John yeoman 595895 595895 Bonar, John, of Campden, yeoman 0
5533829 2515124 2515124 defendant Stylle William barber or yeoman 595895 595895 Stylle, William, of Campden, barber or yeoman 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);