names

31 rows where place_id = 607182

✎ 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
3668014 1915935 1915935 plaintiff Adkyns William   607182 607182 Adkyns, William, of Dodford 0
3668017 1915936 1915936 plaintiff Adkyns William   607182 607182 Adkyns, William, of Dodford 0
4040800 2039201 2039201 defendant Wirley John esq 607182 607182 Wirley, John, of Dodford, esq 0
4040801 2039201 2039201 defendant Angerham or Ingerham Percival yeoman 607182 607182 Angerham or Ingerham, Percival, of Dodford, yeoman 1
4049029 2042097 2042097 defendant Southen John yeoman 607182 607182 Southen, John, of Dodford, yeoman 0
4120545 2067625 2067625 defendant Davye Henry husbandman 607182 607182 Davye, Henry, of Dodford, husbandman 0
4120548 2067626 2067626 defendant Davye Thomas husbandman 607182 607182 Davye, Thomas, of Dodford, husbandman 0
4319433 2136904 2136904 defendant Cooke Richard tiler 607182 607182 Cooke, Richard, of Dodford, tiler 0
4356508 2149508 2149508 defendant Wyrley Henry gent 607182 607182 Wyrley, Henry, of Dodford, gent 0
4470057 2191287 2191287 defendant Pyper John   607182 607182 Pyper, John, of Dodford 2
4501640 2201115 2201115 defendant Stalworth Thomas   607182 607182 Stalworth, Thomas, of Dodford 0
4743597 2278655 2278655 defendant Wylde William esq 607182 607182 Wylde, William, of Dodford, esq 0
4801218 2296564 2296564 defendant Milward William, junior husbandman 607182 607182 Milward, William, junior, of Dodford, husbandman 0
4897356 2325830 2325830 defendant Michell John gent 607182 607182 Michell, John, of Dodford, gent 7
4997974 2356254 2356254 defendant Hogges William husbandman 607182 607182 Hogges, William, of Dodford, husbandman 0
5057985 2373962 2373962 defendant Muscote John yeoman 607182 607182 Muscote, John, of Dodford, yeoman 0
5088536 2383019 2383019 defendant Wylde Thomas esq 607182 607182 Wylde, Thomas, of Dodford, esq 7
5089421 2383278 2383278 defendant Andrewe William clerk 607182 607182 Andrewe, William, of Dodford, clerk 0
5110252 2389405 2389405 defendant Mich- Henry gent 607182 607182 Mich-, Henry, of Dodford, gent 0
5129961 2395251 2395251 defendant Thomas William tilemaker 607182 607182 Thomas, William, of Dodford, tilemaker 1
5164135 2405249 2405249 defendant Parker Agnes widow 607182 607182 Parker, Agnes, of Dodford, widow 0
5177483 2409108 2409108 defendant Parker Agnes widow 607182 607182 Parker, Agnes, of Dodford, widow 0
5200537 2415918 2415918 defendant Parker Agnes widow 607182 607182 Parker, Agnes, of Dodford, widow 0
5315490 2449697 2449697 defendant Cole Fulk yeoman 607182 607182 Cole, Fulk, of Dodford, yeoman 0
5320086 2451099 2451099 defendant Muscote John gent 607182 607182 Muscote, John, of Dodford, or of Stony Stratford, Bucks, gent 0
5494861 2503357 2503357 defendant Coly Fulk gent 607182 607182 Coly, Fulk, of Dodford, gent 0
5494862 2503357 2503357 defendant Mayster John yeoman 607182 607182 Mayster, John, of Dodford, yeoman 1
5494863 2503357 2503357 defendant Norcote John yeoman 607182 607182 Norcote, John, of Dodford, yeoman 2
5556203 2521810 2521810 defendant Stafford Thomas esq 607182 607182 Stafford, Thomas, of Dodford, esq 0
5560558 2523050 2523050 defendant Alybon John husbandman 607182 607182 Alybon, John, of Dodford, husbandman 0
5560559 2523050 2523050 defendant Alybon Robert husbandman 607182 607182 Alybon, Robert, of Dodford, husbandman 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);