names

21 rows where place_id = 587992

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593048 1865453 1865453 defendant Robertes Thomas yeoman 587992 587992 Robertes, Thomas, of Staunton Lacy, yeoman 1
3593053 1865454 1865454 defendant Robertes Thomas yeoman 587992 587992 Robertes, Thomas, of Staunton Lacy, yeoman 1
3692824 1923949 1923949 defendant Brampton William husbandman 587992 587992 Brampton, William, of Staunton Lacy, husbandman 0
3692826 1923950 1923950 defendant Brampton William husbandman 587992 587992 Brampton, William, of Staunton Lacy, husbandman 0
3758714 1944720 1944720 defendant Cotys William yeoman 587992 587992 Cotys, William, of Staunton Lacy, yeoman 0
3764607 1946589 1946589 defendant Jordon William husbandman 587992 587992 Jordon, William, of Staunton Lacy, husbandman 1
3849732 1973504 1973504 defendant Heynes William yeoman of the crown 587992 587992 Heynes, William, of Staunton Lacy, yeoman of the crown 1
3871315 1980657 1980657 defendant Foyle John husbandman 587992 587992 Foyle, John, of Staunton Lacy, husbandman 0
3893442 1988034 1988034 defendant Taverner Henry husbandman 587992 587992 Taverner, Henry, of Staunton Lacy, husbandman 2
4050604 2042645 2042645 defendant Stanwey Edmund her son 587992 587992 Stanwey, Edmund, of Staunton Lacy, husbandman, her son 1
4097163 2059308 2059308 defendant Mond Joan yeoman 587992 587992 Mond, Joan, of Staunton Lacy, yeoman 1
4153454 2079306 2079306 defendant Heynes Peter yeoman 587992 587992 Heynes, Peter, of Staunton Lacy, yeoman 0
4153455 2079306 2079306 defendant Brecknocke Edward yeoman 587992 587992 Brecknocke, Edward, of Staunton Lacy, yeoman 1
4595786 2229933 2229933 plaintiff Roberdes William   587992 587992 Roberdes, William, of Staunton Lacy 0
4603064 2232170 2232170 defendant Erlych John   587992 587992 Erlych, John, of Staunton Lacy 0
4803233 2297203 2297203 defendant Balle John laborer 587992 587992 Balle, John, of Staunton Lacy, laborer 2
4816294 2301180 2301180 defendant Shippe William husbandman 587992 587992 Shippe, William, of Staunton Lacy, husbandman 4
4955436 2343586 2343586 defendant Robertis William yeoman 587992 587992 together with Robertis, William, of Staunton Lacy, yeoman 5
4955437 2343586 2343586 defendant Clerk Maurice husbandman 587992 587992 Clerk, Maurice, of Staunton Lacy, husbandman 6
5348465 2459660 2459660 defendant Cotys William husbandman 587992 587992 Cotys, William, of Staunton Lacy, husbandman 1
5348466 2459660 2459660 defendant Cotys Richard butcher 587992 587992 Cotys, Richard, of Staunton Lacy, butcher 2

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