names

48 rows where place_id = 607171

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3667923 1915909 1915909 defendant Cowper Lawrence clothman 607171 607171 Cowper, Lawrence, of Magna Waldyngfeld, clothman 0
3667929 1915910 1915910 defendant Cowper Lawrence clothman 607171 607171 Cowper, Lawrence, of Magna Waldyngfeld, clothman 0
3671474 1917060 1917060 defendant West John husbandman 607171 607171 West, John, of Magna Waldyngfeld, husbandman 0
3708344 1928905 1928905 defendant Wryght John laborer 607171 607171 Wryght, John, of Magna Waldyngfeld, laborer 1
3708347 1928905 1928905 defendant Baxster John husbandman 607171 607171 Baxster, John, of Magna Waldyngfeld, husbandman 4
3746424 1940802 1940802 defendant Love John husbandman 607171 607171 Love, John, of Magna Waldyngfeld, husbandman 0
3777605 1950748 1950748 defendant Love John husbandman 607171 607171 Love, John, of Magna Waldyngfeld, husbandman 1
3820341 1964240 1964240 defendant Petykan Robert carpenter 607171 607171 Petykan, Robert, of Magna Waldyngfeld, carpenter 0
3836745 1969392 1969392 defendant Holmes Blanche widow 607171 607171 Holmes, Blanche, of Magna Waldyngfeld, widow 0
3836746 1969392 1969392 defendant Holmes William sherman 607171 607171 Holmes, William, of Magna Waldyngfeld, sherman 1
3836747 1969392 1969392 defendant Holmes John sherman 607171 607171 Holmes, John, of Magna Waldyngfeld, sherman 2
3851155 1973952 1973952 defendant Gosse John   607171 607171 Gosse, John, of Magna Waldyngfeld, horse courser 1
3852770 1974473 1974473 defendant Holmes Blanche widow 607171 607171 Holmes, Blanche, of Magna Waldyngfeld, widow 0
3852771 1974473 1974473 defendant Holmes William sherman 607171 607171 Holmes, William, of Magna Waldyngfeld, sherman 1
3852772 1974473 1974473 defendant Holmes John sherman 607171 607171 Holmes, John, of Magna Waldyngfeld, sherman 2
3887736 1986154 1986154 defendant Todde John clothmaker 607171 607171 Todde, John, of Magna Waldyngfeld, clothmaker 0
3895918 1988841 1988841 defendant Todde John sherman 607171 607171 Todde, John, of Magna Waldyngfeld, sherman 1
3908519 1993148 1993148 defendant Smythe James husbandman 607171 607171 Smythe, James, of Magna Waldyngfeld, husbandman 0
3919081 1996705 1996705 defendant Orbell alias Fuller John husbandman 607171 607171 Orbell alias Fuller, John, of Magna Waldyngfeld, husbandman 1
4000881 2025087 2025087 defendant Hubbard William yeoman 607171 607171 Hubbard, William, of Magna Waldyngfeld, yeoman 0
4090285 2056812 2056812 defendant Hubbard William yeoman 607171 607171 Hubbard, William, of Magna Waldyngfeld, yeoman 0
4868278 2317055 2317055 defendant Heryot John weaver 607171 607171 Heryot, John, of Magna Waldyngfeld, weaver 3
4890891 2323898 2323898 defendant Thirston John clerk 607171 607171 Thirston, John, of Magna Waldyngfeld, clerk 0
4904642 2328061 2328061 plaintiff Pouder or Ponder John   607171 607171 Pouder or Ponder, John, of Magna Waldyngfeld 0
4936257 2337738 2337738 defendant Sydey John, senior husbandman 607171 607171 Sydey, John, senior, of Magna Waldyngfeld, husbandman 0
5027271 2364849 2364849 plaintiff Malcher Thomas   607171 607171 Malcher, Thomas, of Magna Waldyngfeld 0
5112200 2389950 2389950 defendant Salman John weaver 607171 607171 Salman, John, of Magna Waldyngfeld, weaver 4
5112201 2389950 2389950 defendant Clerk John yeoman 607171 607171 Clerk, John, of Magna Waldyngfeld, yeoman 5
5230118 2424424 2424424 defendant More Robert weaver 607171 607171 More, Robert, of Magna Waldyngfeld, weaver 2
5230217 2424458 2424458 defendant Pender Robert clothmaker 607171 607171 Pender, Robert, of Magna Waldyngfeld, clothmaker 0
5233916 2425508 2425508 defendant Ponder Robert fuller 607171 607171 Ponder, Robert, of Magna Waldyngfeld, fuller 1
5264725 2434726 2434726 defendant Webbe John yeoman 607171 607171 Webbe, John, of Magna Waldyngfeld, yeoman 0
5284046 2440355 2440355 defendant Glaswright John clothmaker 607171 607171 Glaswright, John, of Magna Waldyngfeld, clothmaker 2
5330005 2454054 2454054 defendant Rudlond William fuller 607171 607171 Rudlond, William, of Magna Waldyngfeld, fuller 1
5331767 2454582 2454582 defendant Siday John, senior husbandman 607171 607171 Siday, John, senior, of Magna Waldyngfeld, husbandman 0
5358767 2462801 2462801 defendant Russell John husbandman 607171 607171 Russell, John, of Magna Waldyngfeld, husbandman 0
5358768 2462801 2462801 defendant Petycan Robert husbandman 607171 607171 Petycan, Robert, of Magna Waldyngfeld, husbandman 1
5358769 2462801 2462801 defendant Salman Thomas weaver 607171 607171 Salman, Thomas, of Magna Waldyngfeld, weaver 2
5481520 2499401 2499401 defendant Rudlond John yeoman 607171 607171 Rudlond, John, of Magna Waldyngfeld, yeoman 2
5481522 2499401 2499401 defendant Heryot Thomas clothmaker 607171 607171 Heryot, Thomas, of Magna Waldyngfeld, clothmaker 4
5483156 2499902 2499902 defendant Heryot Thomas husbandman 607171 607171 Heryot, Thomas, of Magna Waldyngfeld, husbandman 0
5492391 2502640 2502640 defendant Belcham or Beltham John clothmaker 607171 607171 Belcham or Beltham, John, of Magna Waldyngfeld, clothmaker 1
5512461 2508761 2508761 defendant Braybroke Thomas clothmaker 607171 607171 Braybroke, Thomas, of Magna Waldyngfeld, clothmaker 0
5526597 2512886 2512886 defendant Apylton John husbandman 607171 607171 Apylton, John, of Magna Waldyngfeld, husbandman 3
5538000 2516375 2516375 defendant Chamberleyn John carpenter 607171 607171 Chamberleyn, John, of Magna Waldyngfeld, carpenter 1
5558563 2522459 2522459 plaintiff Ponder or Pouder Roger   607171 607171 Ponder or Pouder, Roger, of Magna Waldyngfeld 0
5558568 2522461 2522461 plaintiff Ponder Robert   607171 607171 Ponder, Robert, of Magna Waldyngfeld 0
5558697 2522497 2522497 defendant Appulton John husbandman 607171 607171 Appulton, John, of Magna Waldyngfeld, husbandman 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);