names

33 rows where place_id = 609805

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625583 1875534 1875534 defendant Wilson William   609805 609805 Wilson, William, of Est Grenewych, Kent yeoman 3
3663427 1914488 1914488 defendant Johnson John yeoman 609805 609805 Johnson, John, of East Grenewych, yeoman 1
3680423 1919959 1919959 defendant Monke John carpenter 609805 609805 Monke, John, of Est Grenewych, carpenter 1
3680424 1919959 1919959 defendant Aleyn John waterman 609805 609805 Aleyn, John, of Est Grenewych, waterman 2
3808210 1960449 1960449 defendant Barnwell John yeoman 609805 609805 Barnwell, John, of Est Grenewych, yeoman 3
3819016 1963839 1963839 defendant Russell John gent 609805 609805 Russell, John, of King's household, Est Grenewych, gent 0
4967188 2347117 2347117 defendant Cheseman Robert yeoman 609805 609805 Cheseman, Robert, of Est Grenewych, yeoman 0
5027883 2365037 2365037 defendant Dulle John carpenter 609805 609805 Dulle, John, of Est Grenewych, carpenter 2
5032035 2366243 2366243 defendant Berstalle William butcher 609805 609805 Berstalle, William, of Est Grenewych, butcher 0
5091355 2383870 2383870 defendant Dounyng or Donnyng William cooper 609805 609805 Dounyng or Donnyng, William, of Est Grenewych, cooper 0
5108626 2388957 2388957 defendant Fethirston William carpenter 609805 609805 Fethirston, William, of Est Grenewych, carpenter 1
5112579 2390063 2390063 defendant Cheseman Robert (legal representative) 609805 609805 Cheseman, Robert, of Est Grenewych, executors of 0
5121831 2392816 2392816 defendant Asshby John yeoman 609805 609805 Asshby, John, of Est Grenewych, yeoman 1
5122027 2392857 2392857 defendant Bellacourt John waterman 609805 609805 Bellacourt, John, of Est Grenewych, waterman 0
5132387 2395970 2395970 plaintiff Hatheway (illegible)   609805 609805 Hatheway, ---, of East Grenewych 0
5217505 2420856 2420856 defendant Buk Thomas husbandman 609805 609805 Buk, Thomas, of Est Grenewych, husbandman 0
5217515 2420860 2420860 defendant Steynesmore Simon baker 609805 609805 Steynesmore, Simon, of Est Grenewych, baker 0
5217517 2420861 2420861 defendant Taillour William laborer 609805 609805 Taillour, William, of Est Grenewych, laborer 0
5217518 2420861 2420861 defendant Perys John laborer 609805 609805 Perys, John, of Est Grenewych, laborer 1
5217519 2420861 2420861 defendant Harpyng John husbandman 609805 609805 Harpyng, John, of Est Grenewych, husbandman 2
5268162 2435812 2435812 defendant Touker Robert yeoman 609805 609805 Touker, Robert, of East Grenewych, yeoman 0
5274696 2437676 2437676 defendant Chapman John baker 609805 609805 Chapman, John, of East Grenewych, baker 3
5288833 2441744 2441744 defendant Newark Henry yeoman 609805 609805 Newark, Henry, of Est Grenewych, yeoman 3
5292237 2442728 2442728 defendant Chapman John baker 609805 609805 Chapman, John, of Est Grenewych, baker 1
5294669 2443422 2443422 defendant Payne Robert yeoman 609805 609805 Payne, Robert, of Est Grenewych, yeoman 0
5346962 2459208 2459208 defendant Fouler Joan widow 609805 609805 Fouler, Joan, of Est Grenewych, widow 2
5385987 2471065 2471065 defendant Hanam Thomas husbandman 609805 609805 Hanam, Thomas, of East Grenewych, husbandman 0
5394244 2473415 2473415 defendant Reylond Ralph yeoman 609805 609805 Reylond, Ralph, of East Grenewych, yeoman 0
5471161 2496310 2496310 defendant Hatefeld James beer brewer 609805 609805 Hatefeld, James, of East Grenewych, beer brewer 0
5494203 2503169 2503169 defendant Champney Thomas butcher 609805 609805 Champney, Thomas, of Est Grenewych, butcher 1
5540229 2517073 2517073 defendant Wellis John gent 609805 609805 Wellis, John, of Est Grenewych, gent 0
5615520 2548644 2548644 defendant Hannam John   609805 609805 Hannam, John, of East Grenewych 0
5622168 2550851 2550851 defendant Clerc Thomas   609805 609805 Clerc, Thomas, of East Grenewych 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);