names

34 rows where place_id = 597978

✎ 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
3630643 1904414 1904414 defendant Anne or Aime John gent 597978 597978 Anne or Aime, John, of North Aston, gent 0
4005135 2026619 2026619 plaintiff Kendall William (legal representative) 597978 597978 Kendall, William, of North Aston, executors of 0
4005149 2026622 2026622 plaintiff Kendall William (legal representative) 597978 597978 Kendall, William, of North Aston, yeoman, executors of 0
4005153 2026623 2026623 plaintiff Kendall William (legal representative) 597978 597978 Kendall, William, of North Aston, yeoman, executors of 0
4167097 2083998 2083998 defendant Lee Edward gent 597978 597978 Lee, Edward, of North Aston, gent 0
4301230 2130551 2130551 defendant Ivete Robert   597978 597978 Ivete, Robert, of North Aston, yeoman, wool winder 0
4301290 2130570 2130570 defendant Hixe Nicholas husbandman 597978 597978 Hixe, Nicholas, of North Aston, husbandman 0
4301291 2130570 2130570 defendant Hixe George   597978 597978 Hixe, George, of North Aston, husbandman, his son 1
4578664 2224816 2224816 defendant Payn Thomas   597978 597978 Payn, Thomas, of North Aston 0
4619440 2237071 2237071 defendant Shepherd David   597978 597978 Shepherd, David, of North Aston 0
4636493 2242246 2242246 defendant Ward (illegible)   597978 597978 Ward, _, of North Aston 0
4787452 2292146 2292146 defendant Colles John husbandman 597978 597978 Colles, John, of North Aston, husbandman 0
4787453 2292146 2292146 defendant Crowe Thomas laborer 597978 597978 Crowe, Thomas, of North Aston, laborer 1
4787454 2292146 2292146 defendant Mason Roger laborer 597978 597978 Mason, Roger, of North Aston, laborer 2
4787458 2292147 2292147 defendant Crowe Thomas laborer 597978 597978 together with Crowe, Thomas, of North Aston, laborer 2
4787462 2292149 2292149 defendant Colles John husbandman 597978 597978 Colles, John, of North Aston, husbandman 0
4787464 2292149 2292149 defendant Crowe Thomas laborer 597978 597978 together with Crowe, Thomas, of North Aston, laborer 2
4797280 2295324 2295324 defendant Colles John chapman 597978 597978 Colles, John, of North Aston, chapman 1
4797281 2295324 2295324 defendant Colles Richard husbandman 597978 597978 Colles, Richard, of North Aston, husbandman 2
4804664 2297654 2297654 defendant Gye Richard husbandman 597978 597978 Gye, Richard, of North Aston, husbandman 1
4868164 2317018 2317018 defendant Saltemersshe John husbandman 597978 597978 Saltemersshe, John, of North Aston, husbandman 0
4908498 2329212 2329212 defendant Milward William   597978 597978 Milward, William, of North Aston, milward 0
4990303 2354008 2354008 plaintiff Somerton William   597978 597978 Somerton, William, of North Aston 1
5065739 2376276 2376276 defendant Somerton William esq 597978 597978 Somerton, William, of North Aston, esq 0
5211982 2419242 2419242 defendant Somerton William (legal representative) 597978 597978 Somerton, William, of North Aston, esq, executor of 0
5211985 2419243 2419243 defendant Somerton William (legal representative) 597978 597978 Somerton, William, of North Aston, esq, executor of 0
5226071 2423295 2423295 defendant Boughton John yeoman 597978 597978 Boughton, John, of North Aston, yeoman 1
5226072 2423295 2423295 defendant Myller Roger miller 597978 597978 Myller, Roger, of North Aston, miller 2
5312244 2448699 2448699 defendant Balscote John yeoman 597978 597978 Balscote, John, of North Aston, yeoman 0
5332119 2454684 2454684 defendant Balette John chaplain 597978 597978 Balette, John, of North Aston, chaplain 0
5457485 2492137 2492137 defendant Aune John gent 597978 597978 Aune, John, of North Aston, gent 0
5457486 2492137 2492137 defendant Aune William gent 597978 597978 Aune, William, of North Aston, gent 1
5554224 2521276 2521276 defendant Stacy John yeoman 597978 597978 Stacy, John, of North Aston, yeoman 2
5594699 2533320 2533320 defendant Anne or Aime William (legal representative) 597978 597978 Anne or Aime, William, of North Aston, esq, executor of 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);