names

50 rows where place_id = 589162

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596728 1866612 1866612 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
3622367 1874532 1874532 defendant Heth Thomas butcher 589162 589162 Heth, Thomas, of Kynges Bromley, butcher 0
3759974 1945115 1945115 defendant Agarde Thomas yeoman 589162 589162 Agarde, Thomas, of Kynges Bromley, yeoman 0
3759975 1945115 1945115 defendant Crosse William yeoman 589162 589162 Crosse, William, of Kynges Bromley, yeoman 1
3759976 1945115 1945115 defendant Elton Richard carpenter 589162 589162 Elton, Richard, of Kynges Bromley, carpenter 2
3759977 1945115 1945115 defendant Cobstake Ellen widow 589162 589162 Cobstake, Ellen, of Kynges Bromley, widow 3
3759978 1945115 1945115 defendant Urland Hugh laborer 589162 589162 Urland, Hugh, of Kynges Bromley, laborer 4
3843790 1971593 1971593 defendant Lynton Thomas yeoman 589162 589162 Lynton, Thomas, of Kynges Bromley, yeoman 0
4084003 2054553 2054553 defendant bee John laborer 589162 589162 bee, John, of Kynges Bromley, laborer 5
4462185 2188870 2188870 plaintiff Swan Henry   589162 589162 Swan, Henry, of Kynges Bromley 0
4787460 2292148 2292148 defendant Dedenhall John gent 589162 589162 Dedenhall, John, of Kynges Bromley, gent 0
4868504 2317123 2317123 defendant atte Crosse Thomas husbandman 589162 589162 atte Crosse, Thomas, of Kynges Bromley, husbandman 0
4929941 2335775 2335775 defendant Hathewey John husbandman 589162 589162 Hathewey, John, of Kynges Bromley, husbandman 3
4949063 2341696 2341696 defendant Burgulon Thomas gent 589162 589162 Burgulon, Thomas, of Kynges Bromley, gent 0
4949064 2341696 2341696 defendant Burgulon Robert gent 589162 589162 Burgulon, Robert, of Kynges Bromley, gent 1
4968993 2347689 2347689 defendant Bryde Edmund husbandman 589162 589162 Bryde, Edmund, of Kynges Bromley, husbandman 0
4968997 2347689 2347689 defendant Hathewey John, junior husbandman 589162 589162 (Hathewey, John, junior, of Kynges Bromley, husbandman 4
4968998 2347689 2347689 defendant Crosse John husbandman 589162 589162 Crosse, John, of Kynges Bromley, husbandman 5
4968999 2347689 2347689 defendant Hathewey Thomas husbandman 589162 589162 Hathewey, Thomas, of Kynges Bromley, husbandman 6
4974908 2349468 2349468 defendant Burgulon Thomas gent 589162 589162 Burgulon, Thomas, of Kynges Bromley, gent 0
4974909 2349468 2349468 defendant Burgulon Robert gent 589162 589162 Burgulon, Robert, of Kynges Bromley, gent 1
5114471 2390631 2390631 defendant Cokson William husbandman 589162 589162 Cokson, William, of Kynges Bromley, husbandman 1
5148605 2400717 2400717 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5161026 2404328 2404328 defendant Crosse John, sen husbandman 589162 589162 Crosse, John, sen, of Kynges Bromley, husbandman 0
5161028 2404328 2404328 defendant Recheford John husbandman 589162 589162 Recheford, John, of Kynges Bromley, husbandman 2
5175587 2408544 2408544 defendant Crosse John, sen husbandman 589162 589162 Crosse, John, sen, of Kynges Bromley, husbandman 0
5175589 2408544 2408544 defendant Recheford John husbandman 589162 589162 Recheford, John, of Kynges Bromley, husbandman 2
5183467 2410904 2410904 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5183475 2410905 2410905 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5183483 2410906 2410906 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5196934 2414853 2414853 defendant Recheford John husbandman 589162 589162 Recheford, John, of Kynges Bromley, husbandman 2
5196936 2414854 2414854 defendant Crosse John, sen husbandman 589162 589162 Crosse, John, sen, of Kynges Bromley, husbandman 0
5196938 2414854 2414854 defendant Recheford John husbandman 589162 589162 Recheford, John, of Kynges Bromley, husbandman 2
5221617 2422020 2422020 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5234936 2425798 2425798 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 1
5274414 2437596 2437596 defendant Shelle Richard husbandman 589162 589162 Shelle, Richard, of Kynges Bromley, husbandman 0
5274433 2437600 2437600 defendant Huse Henry gent 589162 589162 Huse, Henry, of Kynges Bromley, gent 0
5291534 2442526 2442526 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5435342 2485507 2485507 defendant Aubey Thomas husbandman 589162 589162 Aubey, Thomas, of Kynges Bromley, husbandman 0
5435344 2485508 2485508 defendant Aubey Thomas husbandman 589162 589162 Aubey, Thomas, of Kynges Bromley, husbandman 0
5435346 2485509 2485509 defendant Anbey or Aubey Thomas husbandman 589162 589162 Anbey or Aubey, Thomas, of Kynges Bromley, husbandman 0
5450389 2490003 2490003 defendant Racheford John husbandman 589162 589162 Racheford, John, of Kynges Bromley, husbandman 0
5495368 2503515 2503515 defendant Mason Robert yeoman 589162 589162 Mason, Robert, of Kynges Bromley, yeoman 2
5526511 2512858 2512858 defendant Smyth Richard yeoman 589162 589162 Smyth, Richard, of Kynges Bromley, yeoman 5
5573776 2526897 2526897 defendant Clare John yeoman 589162 589162 Clare, John, of Kynges Bromley, yeoman 0
5573778 2526897 2526897 defendant Dykke Thomas fuller 589162 589162 Dykke, Thomas, of Kynges Bromley, fuller 2
5604677 2536326 2536326 defendant Motte John yeoman 589162 589162 Motte, John, of Kynges Bromley, yeoman 0
5604678 2536326 2536326 defendant Crosse William husbandman 589162 589162 Crosse, William, of Kynges Bromley, husbandman 1
5608305 2537502 2537502 defendant Lynton John yeoman 589162 589162 Lynton, John, of Kynges Bromley, yeoman 0
5608306 2537502 2537502 defendant Heych-- Thomas laborer 589162 589162 Heych--, Thomas, of Kynges Bromley, laborer 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);