names

35 rows where place_id = 616460

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3714473 1930822 1930822 defendant Cotes Richard tailor 616460 616460 Cotes, Richard, of Brotherton, tailor 0
4040382 2039062 2039062 defendant Merston William yeoman 616460 616460 Merston, William, of Brotherton, yeoman 8
4040421 2039065 2039065 defendant Merston William yeoman 616460 616460 Merston, William, of Brotherton, yeoman 8
4160528 2081755 2081755 defendant Halylye or Hallelay William yeoman 616460 616460 Halylye or Hallelay, William, of Brotherton, yeoman 0
4172714 2085915 2085915 defendant Grene Robert husbandman 616460 616460 Grene, Robert, of Brotherton, husbandman 0
4344383 2145315 2145315 defendant Boulton Edward yeoman 616460 616460 Boulton, Edward, of Brotherton, yeoman 0
4385955 2159993 2159993 defendant Robinson Henry yeoman 616460 616460 Robinson, Henry, of Brotherton, yeoman 0
4385956 2159993 2159993 defendant Robinson Thomas yeoman 616460 616460 Robinson, Thomas, of Brotherton, yeoman 1
4408860 2167561 2167561 defendant Tyndall John gent 616460 616460 Tyndall, John, of Brotherton, gent 0
4408861 2167561 2167561 defendant Shorte Leonard yeoman 616460 616460 Shorte, Leonard, of Brotherton, yeoman 1
4408862 2167561 2167561 defendant Wright William yeoman 616460 616460 Wright, William, of Brotherton, yeoman 2
4448008 2184298 2184298 defendant Hillom John   616460 616460 Hillom, John, of Brotherton, vicar 0
4450979 2185274 2185274 defendant Ingelot Hugh   616460 616460 Ingelot, Hugh, of Brotherton 0
4491520 2198033 2198033 defendant Snell Richard   616460 616460 Snell, Richard, of Brotherton 0
4610636 2234393 2234393 defendant Hill William   616460 616460 Hill, William, of Brotherton 0
4715776 2270252 2270252 defendant Rypon John husbandman 616460 616460 Rypon, John, of Brotherton, husbandman 2
4717315 2270747 2270747 defendant Pycard Richard yeoman 616460 616460 Pycard, Richard, of Brotherton, yeoman 4
4779697 2289638 2289638 defendant Wilbarn William laborer 616460 616460 Wilbarn, William, of Brotherton, laborer 1
4827752 2304727 2304727 defendant del Hill Richard husbandman 616460 616460 del Hill, Richard, of Brotherton, husbandman 2
4883961 2321891 2321891 defendant Welberne John husbandman 616460 616460 Welberne, John, of Brotherton, husbandman 1
4932856 2336662 2336662 defendant del Hill Richard husbandman 616460 616460 del Hill, Richard, of Brotherton, husbandman 0
4990235 2353988 2353988 defendant Pykarde Robert yeoman 616460 616460 Pykarde, Robert, of Brotherton, yeoman 0
4990237 2353989 2353989 defendant Sawemon John yeoman 616460 616460 Sawemon, John, of Brotherton, yeoman 0
4990238 2353989 2353989 defendant Sawemon Robert yeoman 616460 616460 Sawemon, Robert, of Brotherton, yeoman 1
4990239 2353989 2353989 defendant Wilbarne Thomas yeoman 616460 616460 Wilbarne, Thomas, of Brotherton, yeoman 2
5035635 2367280 2367280 defendant Raby Thomas laborer 616460 616460 Raby, Thomas, of Brotherton, laborer 1
5035636 2367280 2367280 defendant Diconson Henry laborer 616460 616460 Diconson, Henry, of Brotherton, laborer 2
5035652 2367284 2367284 defendant Raby Thomas laborer 616460 616460 Raby, Thomas, of Brotherton, laborer 3
5035653 2367284 2367284 defendant Dyconson Henry laborer 616460 616460 Dyconson, Henry, of Brotherton, laborer 4
5070283 2377605 2377605 defendant Mere William laborer 616460 616460 Mere, William, of Brotherton, laborer 0
5070649 2377720 2377720 defendant Mere William laborer 616460 616460 Mere, William, of Brotherton, laborer 0
5288009 2441505 2441505 defendant Mense or Meuse John clerk 616460 616460 Mense or Meuse, John, of Brotherton, clerk 0
5344552 2458464 2458464 defendant Brodgen John husbandman 616460 616460 Brodgen, John, of Brotherton, husbandman 2
5561979 2523486 2523486 plaintiff Watkynson John (legal representative) 616460 616460 Watkynson, John, of Brotherton, gent, administrator of 0
5615967 2548792 2548792 defendant Granby John   616460 616460 Granby, John, of Brotherton 1

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