names

32 rows where place_id = 603801

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655822 1912076 1912076 defendant Baysse William husbandman 603801 603801 Baysse, William, of Dursley, Gloucs, husbandman 3
4504610 2201991 2201991 defendant Harpham John (legal representative) 603801 603801 Harpham, John, of Dursley, Gloucs, administratrix of 6
4504625 2201993 2201993 defendant Harpham John (legal representative) 603801 603801 Harpham, John, of Dursley, Gloucs, executrix of 6
4712603 2269260 2269260 defendant Tanner Thomas husbandman 603801 603801 Tanner, Thomas, of Dursley, Gloucs, husbandman 3
4999291 2356661 2356661 defendant Harryes John carrier 603801 603801 Harryes, John, of Dursley, Gloucs, carrier 1
5135251 2396808 2396808 defendant Tanner Robert gent 603801 603801 Tanner, Robert, of Dursley, Gloucs, gent 2
5147305 2400354 2400354 defendant Badam John clothier 603801 603801 Badam, John, of Dursley, Gloucs, clothier 3
5155379 2402724 2402724 defendant Tanner Robert gent 603801 603801 Tanner, Robert, of Dursley, Gloucs, gent 2
5167063 2406098 2406098 defendant Badam John clothier 603801 603801 Badam, John, of Dursley, Gloucs, clothier 3
5167069 2406099 2406099 defendant Badam John clothier 603801 603801 Badam, John, of Dursley, Gloucs, clothier 3
5177910 2409244 2409244 defendant Tanner Robert gent 603801 603801 Tanner, Robert, of Dursley, Gloucs, gent 3
5182319 2410582 2410582 defendant Badam John clothier 603801 603801 Badam, John, of Dursley, Gloucs, clothier 0
5184004 2411053 2411053 defendant Holwey John fuller 603801 603801 Holwey, John, of Dursley, Gloucs, fuller 3
5201158 2416098 2416098 defendant Tanner Robert gent 603801 603801 Tanner, Robert, of Dursley, Gloucs, gent 3
5201163 2416099 2416099 defendant Tanner Robert gent 603801 603801 Tanner, Robert, of Dursley, Gloucs, gent 3
5204091 2416947 2416947 defendant Holwey John fuller 603801 603801 Holwey, John, of Dursley, Gloucs, fuller 3
5273716 2437392 2437392 defendant Tanner Thomas gent 603801 603801 Tanner, Thomas, of Dursley, Gloucs, gent 1
5369736 2466122 2466122 defendant Wykes John esq 603801 603801 Wykes, John, of Dursley, Gloucs, esq 0
5369740 2466123 2466123 defendant Wykes John esq 603801 603801 Wykes, John, of Dursley, Gloucs, esq 0
5371227 2466585 2466585 defendant Busthr Henry   603801 603801 (Busthr, Henry, of Dursley, Gloucs, cloth man 3
5384459 2470640 2470640 defendant Plymmeswode John clothman 603801 603801 Plymmeswode, John, of Dursley, Gloucs, clothman 0
5387601 2471520 2471520 defendant Woods John esq 603801 603801 Woods, John, of Dursley, Gloucs, esq 0
5387605 2471521 2471521 defendant Wykes John esq 603801 603801 Wykes, John, of Dursley, Gloucs, esq 0
5396292 2474029 2474029 defendant Plymmeswode John   603801 603801 Plymmeswode, John, of Dursley, Gloucs, cloth man 0
5400210 2475134 2475134 defendant Dauys or Danys John   603801 603801 Dauys or Danys, John, of Dursley, Gloucs, cloth maker 0
5400248 2475145 2475145 defendant Wykes John esq 603801 603801 Wykes, John, of Dursley, Gloucs, esq 0
5400252 2475146 2475146 defendant Wykes John esq 603801 603801 Wykes, John, of Dursley, Gloucs, esq 0
5413205 2478872 2478872 defendant Wykes John esq 603801 603801 Wykes, John, of Dursley, Gloucs, esq 0
5434172 2485176 2485176 defendant Wilmot Richard clothmaker 603801 603801 Wilmot, Richard, of Dursley, Gloucs, clothmaker 1
5434173 2485176 2485176 defendant Plymswode John clothmaker 603801 603801 Plymswode, John, of Dursley, Gloucs, clothmaker 2
5441290 2487309 2487309 defendant Wilmot Richard clothmaker 603801 603801 Wilmot, Richard, of Dursley, Gloucs, clothmaker 0
5466572 2494942 2494942 defendant Streti_ E_ren husbandman 603801 603801 Streti_, E_ren, of Dursley, Gloucs, husbandman 2

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