names

33 rows where place_id = 599134

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635425 1905876 1905876 defendant Byrchefeld John maltman 599134 599134 Byrchefeld, John, of Huchyn, maltman 0
3656046 1912143 1912143 defendant Love John wheeler 599134 599134 Love, John, of Huchyn, wheeler 0
3670687 1916796 1916796 plaintiff Buttys Walter (legal representative) 599134 599134 Buttys, Walter, of Huchyn, administratrix of 0
3670693 1916797 1916797 plaintiff Buttys Walter (legal representative) 599134 599134 Buttys, Walter, of Huchyn, administratrix of 0
3670700 1916798 1916798 plaintiff Buttys Walter (legal representative) 599134 599134 Buttys, Walter, of Huchyn, administratrix of 0
3670707 1916799 1916799 plaintiff Buttys Walter (legal representative) 599134 599134 Buttys, Walter, of Huchyn, administratrix of 0
3672921 1917543 1917543 defendant Thorp John baker 599134 599134 Thorp, John, of Huchyn, baker 1
3721230 1932942 1932942 defendant Barker John fuller 599134 599134 Barker, John, of Huchyn, fuller 0
3721231 1932942 1932942 defendant Clerke William chandler 599134 599134 Clerke, William, of Huchyn, chandler 1
3757488 1944315 1944315 defendant Tayler Nicholas maltman 599134 599134 Tayler, Nicholas, of Huchyn, maltman 2
3794655 1956204 1956204 defendant Slette John fisher 599134 599134 Slette, John, of Huchyn, fisher 4
3883328 1984689 1984689 defendant Thurgood John yeoman 599134 599134 Thurgood, John, of Huchyn, yeoman 0
3883330 1984690 1984690 defendant Thurgood John yeoman 599134 599134 Thurgood, John, of Huchyn, yeoman 0
3903960 1991563 1991563 defendant Smyth William butcher 599134 599134 Smyth, William, of Huchyn, butcher 0
3935352 2002136 2002136 defendant Homerston Thomas tanner 599134 599134 (Homerston, Thomas, of Huchyn, tanner 1
3935685 2002244 2002244 defendant Myles Ralph smith 599134 599134 Myles, Ralph, of Huchyn, smith 2
4556130 2217859 2217859 defendant Savage Thomas   599134 599134 Savage, Thomas, of Huchyn 1
4556131 2217859 2217859 defendant Cordewaner John   599134 599134 Cordewaner, John, of Huchyn 2
4662162 2249640 2249640 plaintiff Flecchere Robert   599134 599134 Flecchere, Robert, of Huchyn 0
4665144 2250580 2250580 defendant Barbour Robert barber 599134 599134 Barbour, Robert, of Huchyn, barber 1
4665147 2250581 2250581 defendant Barbour Robert barber 599134 599134 Barbour, Robert, of Huchyn, barber 1
4990354 2354022 2354022 defendant Tristram John husbandman 599134 599134 Tristram, John, of Huchyn, husbandman 0
5008176 2359274 2359274 plaintiff Style John (legal representative) 599134 599134 Style, John, of Huchyn, husbandman, administrator of 0
5017133 2361909 2361909 defendant Bays John butcher 599134 599134 Bays, John, of Huchyn, butcher 1
5021610 2363220 2363220 plaintiff Frankeleyn Lucy   599134 599134 Frankeleyn, Lucy, of Huchyn 0
5057365 2373770 2373770 defendant Chynayn or Chyvayn Heorge shoemaker 599134 599134 Chynayn or Chyvayn, Heorge, of Huchyn, shoemaker 2
5084086 2381743 2381743 defendant Sutton alias Chapman William mercer 599134 599134 Sutton alias Chapman, William, of Huchyn, mercer 1
5117754 2391627 2391627 defendant Parys Lawrence tailor 599134 599134 Parys, Lawrence, of Huchyn, tailor 1
5138707 2397817 2397817 plaintiff Pulter John   599134 599134 Pulter, John, of Huchyn 2
5190072 2412838 2412838 defendant Boston Richard painter 599134 599134 Boston, Richard, of Huchyn, painter 0
5266207 2435184 2435184 defendant Strode Clement baker 599134 599134 Strode, Clement, of Huchyn, baker 0
5345089 2458626 2458626 defendant Holstok William baker 599134 599134 Holstok, William, of Huchyn, baker 0
5421585 2481393 2481393 plaintiff Abbot John   599134 599134 Abbot, John, of Huchyn 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);