names

32 rows where place_id = 761774

✎ 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
4481744 2194992 2194992 defendant Kyng Richard   761774 761774 Kyng, Richard, of Frenyngham 0
4577161 2224368 2224368 defendant Crippes John   761774 761774 Crippes, John, of Frenyngham 0
4709094 2268211 2268211 defendant Robyn John ploughman 761774 761774 Robyn, John, of Frenyngham, ploughman 2
4765458 2285184 2285184 defendant Burys Roger miller 761774 761774 Burys, Roger, of Frenyngham, miller 0
4789725 2292856 2292856 defendant Burys Roger miller 761774 761774 Burys, Roger, of Frenyngham, miller 0
4789727 2292857 2292857 defendant Burys Roger miller 761774 761774 Burys, Roger, of Frenyngham, miller 0
4856094 2313278 2313278 defendant Morewey Ralph laborer 761774 761774 Morewey, Ralph, of Frenyngham, laborer 1
4868416 2317092 2317092 defendant Sacry John husbandman 761774 761774 Sacry, John, of Frenyngham, husbandman 1
4868420 2317093 2317093 defendant Sacry John husbandman 761774 761774 Sacry, John, of Frenyngham, husbandman 0
4933317 2336811 2336811 defendant Burys alias Millere Roger miller 761774 761774 Burys alias Millere, Roger, of Frenyngham, miller 0
4936001 2337660 2337660 defendant Burys Roger miller 761774 761774 Burys, Roger, of Frenyngham, miller 0
4938708 2338491 2338491 defendant Benet Thomas laborer 761774 761774 Benet, Thomas, of Frenyngham, laborer 2
4974351 2349295 2349295 defendant Benet Thomas husbandman 761774 761774 Benet, Thomas, of Frenyngham, husbandman 3
5020171 2362789 2362789 plaintiff Dowle John   761774 761774 Dowle, John, of Frenyngham 0
5020173 2362789 2362789 defendant Spryngfeld John husbandman 761774 761774 Spryngfeld, John, of Frenyngham, husbandman 1
5028243 2365136 2365136 defendant Doule or Donle John yeoman 761774 761774 Doule or Donle, John, of Frenyngham, yeoman 0
5042653 2369408 2369408 plaintiff Dowle John   761774 761774 Dowle, John, of Frenyngham 0
5059091 2374283 2374283 plaintiff Dowle John   761774 761774 Dowle, John, of Frenyngham 0
5065808 2376295 2376295 defendant Dowle John husbandman 761774 761774 Dowle, John, of Frenyngham, husbandman 0
5065809 2376295 2376295 defendant Hunte John soldier 761774 761774 together with Hunte, John, of Frenyngham, soldier 1
5065811 2376295 2376295 defendant Cornelyus Nicholas laborer 761774 761774 Cornelyus, Nicholas, of Frenyngham, laborer 3
5065821 2376298 2376298 defendant Hunte John soldier 761774 761774 Hunte, John, of Frenyngham, soldier 0
5065823 2376298 2376298 defendant Cornelyus Nicholas laborer 761774 761774 Cornelyus, Nicholas, of Frenyngham, laborer 2
5080243 2380581 2380581 defendant Longe Richard husbandman 761774 761774 Longe, Richard, of Frenyngham, husbandman 1
5082535 2381281 2381281 plaintiff Dowle John   761774 761774 Dowle, John, of Frenyngham 0
5087108 2382609 2382609 defendant Longe John husbandman 761774 761774 Longe, John, of Frenyngham, husbandman 0
5087702 2382790 2382790 defendant Bourne John miller 761774 761774 Bourne, John, of Frenyngham, miller 1
5087826 2382820 2382820 defendant Bourne John miller 761774 761774 Bourne, John, of Frenyngham, miller 1
5087827 2382820 2382820 defendant Yonge Roger butcher 761774 761774 Yonge, Roger, of Frenyngham, butcher 2
5182262 2410565 2410565 defendant Doule John husbandman 761774 761774 Doule, John, of Frenyngham, husbandman 0
5203312 2416730 2416730 defendant Doule John husbandman 761774 761774 Doule, John, of Frenyngham, husbandman 0
5333741 2455166 2455166 defendant Bordall Richard clerk 761774 761774 Bordall, Richard, of Frenyngham, 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);