names

32 rows where place_id = 600652

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641926 1907926 1907926 defendant Whyte John yeoman 600652 600652 Whyte, John, of Feny Stratford, yeoman 0
3659964 1913376 1913376 defendant Daldorn alias Tayller Thomas carrier 600652 600652 Daldorn alias Tayller, Thomas, of Feny Stratford, carrier 0
3676626 1918726 1918726 defendant Jonson John   600652 600652 Jonson, John, of Feny Stratford, "coser" 0
3710960 1929742 1929742 defendant Smalle William butcher 600652 600652 Smalle, William, of Feny Stratford, butcher 1
3855537 1975374 1975374 defendant Smyth Thomas shoemaker 600652 600652 Smyth, Thomas, of Feny Stratford, shoemaker 0
3855538 1975374 1975374 defendant Blanche William innholder 600652 600652 Blanche, William, of Feny Stratford, innholder 1
3857250 1975902 1975902 plaintiff Ansty Roger husbandman 600652 600652 Ansty, Roger, of Feny Stratford, husbandman 0
3982203 2018399 2018399 defendant Heathe William husbandman 600652 600652 Heathe, William, of Feny Stratford, husbandman 0
4465311 2189823 2189823 plaintiff Woketon William   600652 600652 Woketon, William, of Feny Stratford 0
4465313 2189824 2189824 plaintiff Woketon William   600652 600652 Woketon, William, of Feny Stratford, on his own account 0
4556527 2217976 2217976 defendant Padworth John   600652 600652 Padworth, John, of Feny Stratford 1
4727389 2273814 2273814 defendant atte Wode Roger butcher 600652 600652 atte Wode, Roger, of Feny Stratford, butcher 1
4727390 2273814 2273814 defendant Bakster Walter yeoman 600652 600652 Bakster, Walter, of Feny Stratford, yeoman 2
4866606 2316515 2316515 defendant Hebbes John butcher 600652 600652 Hebbes, John, of Feny Stratford, butcher 1
4867502 2316804 2316804 defendant Hebbes John butcher 600652 600652 Hebbes, John, of Feny Stratford, butcher 0
4997488 2356100 2356100 plaintiff Hobbys John (legal representative) 600652 600652 Hobbys, John, of Feny Stratford, executor of 0
5087656 2382778 2382778 defendant Hebbes Roger butcher 600652 600652 Hebbes, Roger, of Feny Stratford, butcher 0
5087657 2382778 2382778 defendant Stevens William butcher 600652 600652 Stevens, William, of Feny Stratford, butcher 1
5087658 2382778 2382778 defendant Doget Nicholas butcher 600652 600652 Doget, Nicholas, of Feny Stratford, butcher 2
5087659 2382778 2382778 defendant Kent Richard husbandman 600652 600652 Kent, Richard, of Feny Stratford, husbandman 3
5087661 2382779 2382779 defendant Hobbes Roger butcher 600652 600652 Hobbes, Roger, of Feny Stratford, butcher 0
5087662 2382779 2382779 defendant Stevenes William butcher 600652 600652 Stevenes, William, of Feny Stratford, butcher 1
5087663 2382779 2382779 defendant Doggee Nicholas butcher 600652 600652 Doggee, Nicholas, of Feny Stratford, butcher 2
5224376 2422806 2422806 defendant Draper Lawrence husbandman 600652 600652 Draper, Lawrence, of Feny Stratford, husbandman 0
5237847 2426653 2426653 defendant Hebbes Roger husbandman 600652 600652 Hebbes, Roger, of Feny Stratford, husbandman 1
5253591 2431232 2431232 defendant Chamberleyn Robert barber 600652 600652 Chamberleyn, Robert, of Feny Stratford, barber 0
5287055 2441224 2441224 plaintiff Hyppyswell Gilbert yeoman 600652 600652 Hyppyswell, Gilbert, of Feny Stratford, yeoman 0
5287056 2441224 2441224 defendant Draper Lawrence yeoman 600652 600652 Draper, Lawrence, of Feny Stratford, yeoman 0
5304721 2446408 2446408 plaintiff Hyppeswell Gilbert   600652 600652 Hyppeswell, Gilbert, of Feny Stratford 0
5328063 2453462 2453462 defendant Covyngton or Conyngton William baker 600652 600652 Covyngton or Conyngton, William, of Feny Stratford, baker 0
5328065 2453463 2453463 defendant Covyngton William baker 600652 600652 Covyngton, William, of Feny Stratford, baker 0
5397189 2474281 2474281 defendant Ganno Hugh yeoman 600652 600652 Ganno, Hugh, of Feny Stratford, yeoman 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);