names

38 rows where place_id = 587506

✎ 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
3591593 1864994 1864994 defendant Sewester John gent 587506 587506 Sewester, John, of Asshwell, gent 2
3603748 1868843 1868843 defendant Tadlowe John baker 587506 587506 Tadlowe, John, of Asshwell, baker 0
3603749 1868843 1868843 defendant Bygrave John husbandman 587506 587506 Bygrave, John, of Asshwell, husbandman 1
3603750 1868843 1868843 defendant Phylyp William husbandman 587506 587506 Phylyp, William, of Asshwell, husbandman 2
3613478 1871863 1871863 plaintiff Barley William gent 587506 587506 Barley, William, of Asshwell, gent 0
3615370 1872450 1872450 defendant Philip John carpenter 587506 587506 Philip, John, of Asshwell, carpenter 0
3615371 1872450 1872450 defendant Tailer John butcher 587506 587506 Tailer, John, of Asshwell, butcher 1
3625377 1875477 1875477 defendant Shypman John baker 587506 587506 Shypman, John, of Asshwell, baker 0
3625612 1875543 1875543 defendant Barle William yeoman 587506 587506 Barle, William, of Asshwell, yeoman 0
3631375 1904624 1904624 defendant Wryght John husbandman 587506 587506 Wryght, John, of Asshwell, husbandman 0
3659810 1913322 1913322 defendant Starlyng Robert tailor 587506 587506 Starlyng, Robert, of Asshwell, tailor 1
3712607 1930258 1930258 defendant Pykard Thomas butcher 587506 587506 Pykard, Thomas, of Asshwell, butcher 1
3937410 2002846 2002846 defendant Rayner William carpenter 587506 587506 Rayner, William, of Asshwell, carpenter 3
3947287 2006120 2006120 defendant Wryght Thomas tiler 587506 587506 Wryght, Thomas, of Asshwell, tiler 0
3998065 2024067 2024067 plaintiff Everett Robert, junior maltster 587506 587506 Everett, Robert, junior, of Asshwell, maltster 0
4038574 2038436 2038436 defendant Nycolles Hamon husbandman 587506 587506 Nycolles, Hamon, of Asshwell, husbandman 1
4734635 2275992 2275992 defendant Smyth Nicholas smith 587506 587506 Smyth, Nicholas, of Asshwell, smith 3
4816667 2301308 2301308 plaintiff Freman William   587506 587506 Freman, William, of Asshwell, gent, on their own account 1
4816670 2301309 2301309 plaintiff Freman William   587506 587506 Freman, William, of Asshwell, gent, on their own account 1
4889389 2323475 2323475 defendant Amery Thomas bowyer 587506 587506 Amery, Thomas, of Asshwell, bowyer 0
4968198 2347440 2347440 plaintiff Freman William   587506 587506 Freman, William, of Asshwell 0
5068868 2377186 2377186 defendant Marchall Alexander esq 587506 587506 Marchall, Alexander, of Asshwell, esq 0
5073960 2378696 2378696 defendant Abell Thomas roper 587506 587506 Abell, Thomas, of Asshwell, roper 0
5073962 2378697 2378697 defendant Glove William husbandman 587506 587506 Glove, William, of Asshwell, husbandman 0
5077076 2379642 2379642 defendant atte Well Robert husbandman 587506 587506 atte Well, Robert, of Asshwell, husbandman 0
5084090 2381744 2381744 defendant Saunder John   587506 587506 Saunder, John, of Asshwell, mason 0
5094841 2384905 2384905 defendant Borell Henry husbandman 587506 587506 Borell, Henry, of Asshwell, husbandman 0
5097991 2385843 2385843 defendant Borell Henry husbandman 587506 587506 Borell, Henry, of Asshwell, husbandman 0
5219475 2421420 2421420 defendant Freman Alice widow 587506 587506 (Freman, Alice, of Asshwell, widow 5
5284232 2440408 2440408 defendant Fuller Thomas draper 587506 587506 Fuller, Thomas, of Asshwell, draper 1
5285701 2440845 2440845 defendant Vynter John gent 587506 587506 Vynter, John, of Asshwell, gent 0
5320504 2451217 2451217 defendant Sewall John shoemaker 587506 587506 Sewall, John, of Asshwell, shoemaker 0
5360352 2463272 2463272 defendant Lowde William shoemaker 587506 587506 Lowde, William, of Asshwell, shoemaker 4
5423496 2481988 2481988 defendant Bygrave William husbandman 587506 587506 Bygrave, William, of Asshwell, husbandman 0
5505821 2506742 2506742 defendant Reve or Rene Martin husbandman 587506 587506 Reve or Rene, Martin, of Asshwell, husbandman 1
5505822 2506742 2506742 defendant Wellys Robert husbandman 587506 587506 Wellys, Robert, of Asshwell, husbandman 2
5608915 2537689 2537689 defendant Lecheworth John butcher 587506 587506 Lecheworth, John, of Asshwell, butcher 1
5625295 2551849 2551849 plaintiff Lymebrynnere William   587506 587506 Lymebrynnere, William, of Asshwell 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);