names

27 rows where place_id = 642391

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3867656 1979417 1979417 plaintiff Shelton Ralph esq 642391 642391 Shelton, Ralph, of Broom, esq 0
4465913 2190006 2190006 defendant Polkyn Adam   642391 642391 Polkyn, Adam, of Broom 0
4465916 2190006 2190006 defendant Thurlebergh William   642391 642391 Thurlebergh, William, of Broom 3
4465982 2190020 2190020 defendant Polkyn Adam   642391 642391 Polkyn, Adam, of Broom 0
4465985 2190020 2190020 defendant Thurlebergh William   642391 642391 Thurlebergh, William, of Broom 3
4517846 2205967 2205967 defendant Smyth John   642391 642391 Smyth, John, of Broom 4
4585748 2226965 2226965 defendant smyth John   642391 642391 smyth, John, of Broom 3
4721850 2272166 2272166 defendant Wyltoft John husbandman 642391 642391 Wyltoft, John, of Broom, husbandman 0
4725561 2273283 2273283 defendant Ballard John   642391 642391 Ballard, John, of Broom, corn loader 2
4741548 2278023 2278023 defendant Pokkyn Thomas husbandman 642391 642391 Pokkyn, Thomas, of Broom, husbandman 2
4749535 2280344 2280344 defendant Swan John laborer 642391 642391 Swan, John, of Broom, laborer 1
4757346 2282670 2282670 defendant Polkyn John husbandman 642391 642391 Polkyn, John, of Broom, husbandman 1
4775509 2288333 2288333 defendant Lacy John butcher 642391 642391 Lacy, John, of Broom, butcher 1
4775510 2288333 2288333 defendant Keggel Thomas husbandman 642391 642391 Keggel, Thomas, of Broom, husbandman 2
4803154 2297180 2297180 defendant Broom John gent 642391 642391 Broom, John, of Broom, son of Robert, gent 2
4809507 2299146 2299146 defendant Kegyll Thomas yeoman 642391 642391 Kegyll, Thomas, of Broom, yeoman 0
4862753 2315337 2315337 defendant Haill Augustine   642391 642391 Haill, Augustine, of Broom, corn loader 0
4879988 2320654 2320654 defendant Pascale John yeoman 642391 642391 Pascale, John, of Broom, yeoman 2
4882168 2321326 2321326 plaintiff Aldham Simon   642391 642391 Aldham, Simon, of Broom 1
4903647 2327756 2327756 defendant Pascale John yeoman 642391 642391 Pascale, John, of Broom, yeoman 1
4930722 2336018 2336018 defendant Kegyll Alice widow 642391 642391 Kegyll, Alice, of Broom, widow 0
4930723 2336018 2336018 defendant Kegyll Richard clerk 642391 642391 Kegyll, Richard, of Broom, clerk 1
5054459 2372908 2372908 defendant Crouland William husbandman 642391 642391 Crouland, William, of Broom, husbandman 0
5232801 2425178 2425178 defendant Bromley John yeoman 642391 642391 Bromley, John, of Broom, yeoman 5
5234392 2425648 2425648 defendant Hervy John yeoman 642391 642391 Hervy, John, of Broom, yeoman 1
5316048 2449875 2449875 defendant Hervy John yeoman 642391 642391 Hervy, John, of Broom, yeoman 2
5547700 2519342 2519342 defendant Merday John   642391 642391 Merday, John, of Broom, ploughwright 3

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);