names

21 rows where place_id = 620700

✎ 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
3737145 1937851 1937851 defendant Byrde John husbandman 620700 620700 Byrde, John, of West Bromwiche, husbandman 0
3865738 1978766 1978766 defendant Russheton John   620700 620700 Russheton, John, of West Bromwiche, horse courser 0
3865739 1978766 1978766 defendant Ryder Robert   620700 620700 Ryder, Robert, of West Bromwiche, horse courser 1
3870426 1980353 1980353 defendant Rusheton John courser 620700 620700 Rusheton, John, of West Bromwiche, courser 0
3992010 2021908 2021908 defendant Hopkys John (legal representative) 620700 620700 Hopkys, John, of West Bromwiche, cooper, executors of 0
3992011 2021908 2021908 defendant Clare William cooper 620700 620700 (Clare, William, of West Bromwiche, cooper 1
4071808 2050215 2050215 defendant Partrydge John husbandman 620700 620700 Partrydge, John, of West Bromwiche, husbandman 2
4071809 2050216 2050216 plaintiff Neweye William smith 620700 620700 Neweye, William, of West Bromwiche, smith 0
4077008 2052060 2052060 defendant Raynold Anthony (legal representative) 620700 620700 Raynold, Anthony, of West Bromwiche, gent, executors of 0
4189175 2091706 2091706 defendant Hardwicke John tailor 620700 620700 Hardwicke, John, of West Bromwiche, tailor 0
4189176 2091706 2091706 defendant Hardwicke Thomas carpenter 620700 620700 Hardwicke, Thomas, of West Bromwiche, carpenter 1
4212743 2099997 2099997 defendant Wylye John carpenter 620700 620700 Wylye, John, of West Bromwiche, carpenter 0
4321611 2137647 2137647 defendant Astnor Edward nailer 620700 620700 Astnor, Edward, of West bromwiche, nailer 1
4321612 2137647 2137647 defendant Norrys John nailer 620700 620700 Norrys, John, of West bromwiche, nailer 2
4328440 2139827 2139827 defendant Hopkys Richard   620700 620700 Hopkys, Richard, of West Bromwiche, buckle maker 0
4328442 2139827 2139827 defendant Kynnersley John yeoman 620700 620700 Kynnersley, John, of West Bromwiche, yeoman 2
4332515 2141164 2141164 defendant Woodward John yeoman 620700 620700 Woodward, John, of West Bromwiche, yeoman 0
4351992 2147931 2147931 defendant Alexander John gent 620700 620700 Alexander, John, of West Bromwiche, gent 2
4391563 2161790 2161790 defendant Woodward George nailer 620700 620700 Woodward, George, of West Bromwiche, nailer 0
4409471 2167764 2167764 defendant Ashmore Edward nailer 620700 620700 Ashmore, Edward, of West Bromwiche, nailer 1
5312487 2448770 2448770 defendant Gouter or Gonter William laborer 620700 620700 Gouter or Gonter, William, of West Bromwiche, laborer 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);