names

32 rows where place_id = 657503

✎ 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
3944583 2005204 2005204 defendant Whitheade Edward husbandman 657503 657503 Whitheade, Edward, of Kyllome, husbandman 1
3965462 2012534 2012534 defendant Fusedale John yeoman 657503 657503 Fusedale, John, of Kyllome, yeoman 2
3965464 2012535 2012535 defendant Kerye Thomas husbandman 657503 657503 Kerye, Thomas, of Kyllome, husbandman 0
3965471 2012536 2012536 defendant Johnson Thomas husbandman 657503 657503 Johnson, Thomas, of Kyllome, husbandman 5
3965472 2012536 2012536 defendant Bilbye John husbandman 657503 657503 Bilbye, John, of Kyllome, husbandman 6
3965477 2012537 2012537 defendant Whitheade Richard husbandman 657503 657503 Whitheade, Richard, of Kyllome, husbandman 0
3965480 2012538 2012538 defendant Whitheade Richard husbandman 657503 657503 Whitheade, Richard, of Kyllome, husbandman 0
3965481 2012538 2012538 defendant Powley Anthony husbandman 657503 657503 Powley, Anthony, of Kyllome, husbandman 1
3989823 2021111 2021111 defendant Dalton Leonard husbandman 657503 657503 Dalton, Leonard, of Kyllome, husbandman 0
3989825 2021112 2021112 defendant Dalton Leonard husbandman 657503 657503 Dalton, Leonard, of Kyllome, husbandman 0
3989827 2021113 2021113 defendant Fenbye Joan widow 657503 657503 Fenbye, Joan, of Kyllome, widow 0
3989828 2021113 2021113 defendant Megson Alexander yeoman 657503 657503 Megson, Alexander, of Kyllome, yeoman 1
3989830 2021114 2021114 defendant Megson Alexander yeoman 657503 657503 Megson, Alexander, of Kyllome, yeoman 0
3989831 2021114 2021114 defendant Megson Paul yeoman 657503 657503 Megson, Paul, of Kyllome, yeoman 1
3989832 2021114 2021114 defendant Howson Stephen yeoman 657503 657503 Howson, Stephen, of Kyllome, yeoman 2
3989833 2021114 2021114 defendant Kyrkbye Thomas yeoman 657503 657503 Kyrkbye, Thomas, of Kyllome, yeoman 3
3990403 2021323 2021323 defendant Bawne John yeoman 657503 657503 Bawne, John, of Kyllome, yeoman 0
3990405 2021324 2021324 defendant Bawne John yeoman 657503 657503 Bawne, John, of Kyllome, yeoman 0
3990407 2021325 2021325 defendant Farthinge Michael yeoman 657503 657503 Farthinge, Michael, of Kyllome, yeoman 0
3990408 2021325 2021325 defendant Farthinge Richard, junior yeoman 657503 657503 Farthinge, Richard, junior, of Kyllome, yeoman 1
3997170 2023758 2023758 plaintiff Drynkrowe Thomas yeoman 657503 657503 Drynkrowe, Thomas, of Kyllome, yeoman 0
4011517 2028873 2028873 defendant Martine Thomas husbandman 657503 657503 Martine, Thomas, of Kyllome, husbandman 0
4011518 2028873 2028873 defendant Coleman William husbandman 657503 657503 Coleman, William, of Kyllome, husbandman 1
4011519 2028873 2028873 defendant Mekeley William miller 657503 657503 Mekeley, William, of Kyllome, miller 2
4014167 2029794 2029794 defendant Skowthorpe John yeoman 657503 657503 Skowthorpe, John, of Kyllome, yeoman 0
4023788 2033211 2033211 defendant Bewycke Christopher yeoman 657503 657503 Bewycke, Christopher, of Kyllome, yeoman 0
4054930 2044156 2044156 defendant Bewcoke Christopher yeoman 657503 657503 Bewcoke, Christopher, of Kyllome, yeoman 0
4062168 2046758 2046758 defendant Bewick Christopher yeoman 657503 657503 Bewick, Christopher, of Kyllome, yeoman 0
4075876 2051675 2051675 plaintiff Scothorpe Thomas yeoman 657503 657503 Scothorpe, Thomas, of Kyllome, yeoman 0
4077162 2052117 2052117 defendant Skethorpe or Skothorpe John yeoman 657503 657503 Skethorpe or Skothorpe, John, of Kyllome, yeoman 0
4604593 2232599 2232599 defendant Salvan Thomas   657503 657503 Salvan, Thomas, of Kyllome 0
4604598 2232600 2232600 defendant Walker William   657503 657503 Walker, William, of Kyllome 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);