names

42 rows where place_id = 585944

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587544 1863753 1863753 defendant Sheldon Henry gent 585944 585944 Sheldon, Henry, of Pershore, Worcs, gent 0
3588059 1863916 1863916 defendant Russell John chapman 585944 585944 Russell, John, of Pershore, Worcs, chapman 0
3597280 1866769 1866769 defendant Russell John mercer 585944 585944 Russell, John, of Pershore, Worcs, mercer 0
3599649 1867532 1867532 defendant Russell John chapman 585944 585944 Russell, John, of Pershore, Worcs, chapman 0
3705493 1928009 1928009 defendant Turve Richard yeoman 585944 585944 Turve, Richard, of Pershore, Worcs, yeoman 0
3705501 1928010 1928010 defendant Turve Richard yeoman 585944 585944 Turve, Richard, of Pershore, Worcs, yeoman 0
3705509 1928011 1928011 defendant Turve Richard yeoman 585944 585944 Turve, Richard, of Pershore, Worcs, yeoman 0
3705798 1928094 1928094 defendant Turve Richard yeoman 585944 585944 Turve, Richard, of Pershore, Worcs, yeoman 0
4362924 2151800 2151800 defendant Richardson Thomas gent 585944 585944 Richardson, Thomas, of Pershore, Worcs, gent 0
4628240 2239759 2239759 defendant Latoner John taverner 585944 585944 Latoner, John, of Pershore, Worcs, taverner 3
4704549 2266799 2266799 defendant Pegeon Edmund gent 585944 585944 Pegeon, Edmund, of Pershore, Worcs, gent 0
4818159 2301754 2301754 plaintiff Newenton William   585944 585944 Newenton, William, of Pershore, Worcs, abbot 0
4818161 2301755 2301755 plaintiff Newenton William   585944 585944 Newenton, William, of Pershore, Worcs, abbot 0
4818163 2301756 2301756 plaintiff Newenton William   585944 585944 Newenton, William, of Pershore, Worcs, abbot 0
4818165 2301757 2301757 plaintiff Newenton William   585944 585944 Newenton, William, of Pershore, Worcs, abbot 0
4825649 2304060 2304060 plaintiff Vampage John   585944 585944 Vampage, John, of Pershore, Worcs 0
4852937 2312341 2312341 defendant Dyer Richard dyer 585944 585944 Dyer, Richard, of Pershore, Worcs, dyer 2
4871712 2318121 2318121 defendant Rogerys alias Dyer Richard dyer 585944 585944 Rogerys alias Dyer, Richard, of Pershore, Worcs, dyer 0
4931488 2336229 2336229 defendant Newenton William   585944 585944 Newenton, William, of Pershore, Worcs, abbot of St Mary's 0
4944320 2340198 2340198 defendant Broun John husbandman 585944 585944 (Broun, John, of Pershore, Worcs, husbandman 1
5010270 2359868 2359868 defendant Chercheman John weaver 585944 585944 Chercheman, John, of Pershore, Worcs, weaver 0
5050138 2371665 2371665 defendant Wever Thomas chapman 585944 585944 Wever, Thomas, of Pershore, Worcs, chapman 2
5251225 2430486 2430486 defendant Wever Thomas weaver 585944 585944 Wever, Thomas, of Pershore, Worcs, weaver 0
5277695 2438562 2438562 defendant Costenette William yeoman 585944 585944 Costenette, William, of Pershore, Worcs, yeoman 0
5299372 2444790 2444790 defendant Walker Thomas tailor 585944 585944 Walker, Thomas, of Pershore, Worcs, tailor 1
5341564 2457550 2457550 defendant Russell John chapman 585944 585944 Russell, John, of Pershore, Worcs, chapman 2
5365673 2464928 2464928 defendant Crompe Richard chapman 585944 585944 Crompe, Richard, of Pershore, Worcs, chapman 0
5365700 2464933 2464933 defendant Russell John mercer 585944 585944 Russell, John, of Pershore, Worcs, mercer 2
5369481 2466048 2466048 defendant Cossevet or Cossenet William yeoman 585944 585944 Cossevet or Cossenet, William, of Pershore, Worcs, yeoman 0
5370469 2466347 2466347 defendant Mathew Thomas   585944 585944 Mathew, Thomas, of Pershore, Worcs, cloth man 1
5386039 2471079 2471079 defendant Russele John chapman 585944 585944 Russele, John, of Pershore, Worcs, chapman 0
5398263 2474574 2474574 defendant Russlee John chapman 585944 585944 Russlee, John, of Pershore, Worcs, chapman 0
5411393 2478368 2478368 defendant Russell John chapman 585944 585944 Russell, John, of Pershore, Worcs, chapman 0
5423317 2481934 2481934 defendant Crompe Richard chapman 585944 585944 Crompe, Richard, of Pershore, Worcs, chapman 1
5442660 2487718 2487718 defendant (illegible) John chapman 585944 585944 _, John, of Pershore, Worcs, chapman 0
5477752 2498363 2498363 defendant Baron Thomas husbandman 585944 585944 Baron, Thomas, of Pershore, Worcs, husbandman 3
5492141 2502559 2502559 defendant Hareys John chapman 585944 585944 (Hareys, John, of Pershore, Worcs, chapman 1
5504954 2506467 2506467 defendant Harwell Roger esq 585944 585944 Harwell, Roger, of Pershore, Worcs, esq 0
5505383 2506599 2506599 defendant Russell John mercer 585944 585944 Russell, John, of Pershore, Worcs, mercer 0
5514129 2509265 2509265 defendant Danes alias Harres John tailor 585944 585944 Danes alias Harres, John, of Pershore, Worcs, tailor 0
5514145 2509270 2509270 defendant Danes alias Harres John tailor 585944 585944 Danes alias Harres, John, of Pershore, Worcs, tailor 0
5515281 2509623 2509623 defendant Russell John chapman 585944 585944 Russell, John, of Pershore, Worcs, chapman 4

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