names

31 rows where place_id = 639285

✎ 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
3847974 1972941 1972941 defendant Blakburne Thomas yeoman 639285 639285 Blakburne, Thomas, of Myrfeld, yeoman 0
4064922 2047738 2047738 defendant Walker John laborer 639285 639285 Walker, John, of Myrfeld, laborer 3
4075801 2051645 2051645 plaintiff Savile Elizabeth widow 639285 639285 Savile, Elizabeth, of Myrfeld, widow 0
4075805 2051646 2051646 plaintiff Savile Elizabeth widow 639285 639285 Savile, Elizabeth, of Myrfeld, widow 0
4075815 2051648 2051648 defendant Scotte John husbandman 639285 639285 Scotte, John, of Myrfeld, husbandman 2
4075816 2051649 2051649 plaintiff Savyle Elizabeth gent 639285 639285 Savyle, Elizabeth, of Myrfeld, widow of Thomas Savile, of Clyfton, gent 0
4075819 2051649 2051649 defendant Scotte John husbandman 639285 639285 Scotte, John, of Myrfeld, husbandman 2
4087895 2055962 2055962 defendant Man William clothier 639285 639285 Man, William, of Myrfeld, clothier 0
4087898 2055962 2055962 defendant Hepworth John husbandman 639285 639285 Hepworth, John, of Myrfeld, husbandman 3
4102539 2061208 2061208 defendant Beamonte Alice widow 639285 639285 Beamonte, Alice, of Myrfeld, widow 1
4102540 2061208 2061208 defendant Senyor Thomas husbandman 639285 639285 Senyor, Thomas, of Myrfeld, husbandman 2
4110465 2064005 2064005 defendant Walker John husbandman 639285 639285 Walker, John, of Myrfeld, husbandman 0
4136849 2073528 2073528 plaintiff Savyle Thomas   639285 639285 Savyle, Thomas, of Myrfeld, gent, "my near kinsman" 1
4176237 2087165 2087165 defendant Haldesworth John yeoman 639285 639285 Haldesworth, John, of Myrfeld, yeoman 0
4176239 2087166 2087166 defendant Haldesworthe John yeoman 639285 639285 Haldesworthe, John, of Myrfeld, yeoman 0
4188330 2091422 2091422 defendant Tomson William clothier 639285 639285 Tomson, William, of Myrfeld, clothier 3
4224420 2104025 2104025 defendant Ledgerd John yeoman 639285 639285 Ledgerd, John, of Myrfeld, yeoman 0
4224421 2104025 2104025 defendant Ledgerd William husbandman 639285 639285 Ledgerd, William, of Myrfeld, husbandman 1
4224422 2104025 2104025 defendant Blackborne Thomas husbandman 639285 639285 Blackborne, Thomas, of Myrfeld, husbandman 2
5120224 2392355 2392355 defendant Sokkys Thomas husbandman 639285 639285 Sokkys, Thomas, of Myrfeld, husbandman 1
5134100 2396470 2396470 defendant Mylner alias Myrfeld Walter husbandman 639285 639285 Mylner alias Myrfeld, Walter, of Myrfeld, husbandman 2
5154016 2402335 2402335 defendant Milner Walter husbandman 639285 639285 Milner, Walter, of Myrfeld, husbandman 2
5171256 2407314 2407314 defendant Mylner Walter husbandman 639285 639285 Mylner, Walter, of Myrfeld, husbandman 2
5340155 2457128 2457128 defendant Ine or Ive Henry husbandman 639285 639285 Ine or Ive, Henry, of Myrfeld, husbandman 4
5340160 2457129 2457129 defendant Ine or Ive Henry husbandman 639285 639285 Ine or Ive, Henry, of Myrfeld, husbandman 3
5349384 2459939 2459939 defendant Lee Edmund husbandman 639285 639285 Lee, Edmund, of Myrfeld, husbandman 0
5349385 2459939 2459939 defendant Jepson Richard husbandman 639285 639285 Jepson, Richard, of Myrfeld, husbandman 1
5354893 2461606 2461606 defendant Ine or Ive Henry miller 639285 639285 Ine or Ive, Henry, of Myrfeld, miller 0
5354894 2461606 2461606 defendant Smyth William shoemaker 639285 639285 Smyth, William, of Myrfeld, shoemaker 1
5356054 2461973 2461973 defendant Barker William cordainer 639285 639285 Barker, William, of Myrfeld, cordainer 2
5435970 2485700 2485700 defendant Worthyngton Robert yeoman 639285 639285 Worthyngton, Robert, of Myrfeld, yeoman 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);