names

34 rows where place_id = 600293

✎ 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
3640485 1907455 1907455 defendant Hamond Roger husbandman 600293 600293 Hamond, Roger, of Westmyll, husbandman 0
3675693 1918429 1918429 defendant Cheperfeld Thomas yeoman 600293 600293 Cheperfeld, Thomas, of Westmyll, yeoman 1
3678605 1919367 1919367 defendant Cheperfeld Thomas husbandman 600293 600293 Cheperfeld, Thomas, of Westmyll, husbandman 0
3682187 1920534 1920534 defendant Hamond William, senior husbandman 600293 600293 Hamond, William, senior, of Westmyll, husbandman 0
3770686 1948513 1948513 defendant Broun William husbandman 600293 600293 Broun, William, of Westmyll, husbandman 3
3774877 1949872 1949872 defendant Broun Thomas husbandman 600293 600293 Broun, Thomas, of Westmyll, husbandman 2
3775953 1950226 1950226 defendant Auncell Richard husbandman 600293 600293 Auncell, Richard, of Westmyll, husbandman 1
3831698 1967814 1967814 defendant Cheperfeld Thomas laborer 600293 600293 Cheperfeld, Thomas, of Westmyll, laborer 0
3836304 1969263 1969263 defendant Newnam John husbandman 600293 600293 Newnam, John, of Westmyll, husbandman 2
3839964 1970428 1970428 defendant Harryes Edward smith 600293 600293 Harryes, Edward, of Westmyll, smith 1
3853121 1974595 1974595 defendant Broune William laborer 600293 600293 Broune, William, of Westmyll, laborer 0
3896921 1989182 1989182 defendant Crouche John laborer 600293 600293 Crouche, John, of Westmyll, laborer 1
4172707 2085912 2085912 defendant Brand Robert husbandman 600293 600293 Brand, Robert, of Westmyll, husbandman 2
4274149 2120901 2120901 defendant Meryton Joan spinster 600293 600293 Meryton, Joan, of Westmyll, spinster 0
4309433 2133461 2133461 defendant Meryton Joan spinster 600293 600293 Meryton, Joan, of Westmyll, spinster 0
4395129 2162959 2162959 defendant Jackson John maltman 600293 600293 Jackson, John, of Westmyll, maltman 1
4611078 2234530 2234530 defendant Bernard Thomas   600293 600293 Bernard, Thomas, of Westmyll 1
4611267 2234587 2234587 defendant Gayle William   600293 600293 Gayle, William, of Westmyll 2
4632761 2241132 2241132 defendant Chipirvyle Thomas   600293 600293 Chipirvyle, Thomas, of Westmyll 1
4643478 2244192 2244192 defendant Taillour John   600293 600293 Taillour, John, of Westmyll 0
4939134 2338626 2338626 plaintiff Colston Robert clerk 600293 600293 Colston, Robert, of Westmyll, clerk 0
4939135 2338626 2338626 defendant Warde Thomas husbandman 600293 600293 Warde, Thomas, of Westmyll, husbandman 0
5013460 2360773 2360773 defendant Munden John   600293 600293 Munden, John, of Westmyll, servant 0
5124448 2393610 2393610 defendant Wyndonte Johh husbandman 600293 600293 Wyndonte, Johh, of Westmyll, husbandman 0
5153605 2402206 2402206 defendant Wyndoute John husbandman 600293 600293 Wyndoute, John, of Westmyll, husbandman 0
5187690 2412117 2412117 defendant Broun Thomas maltman 600293 600293 Broun, Thomas, of Westmyll, maltman 0
5189047 2412529 2412529 defendant Wyndoute John husbandman 600293 600293 Wyndoute, John, of Westmyll, husbandman 0
5205528 2417363 2417363 defendant Broun Thomas maltman 600293 600293 Broun, Thomas, of Westmyll, maltman 0
5326193 2452927 2452927 defendant Stokkes William husbandman 600293 600293 Stokkes, William, of Westmyll, husbandman 0
5354176 2461370 2461370 defendant Chery Philip laborer 600293 600293 Chery, Philip, of Westmyll, laborer 4
5380578 2469496 2469496 defendant Phelips Edmund carpenter 600293 600293 Phelips, Edmund, of Westmyll, carpenter 1
5410635 2478126 2478126 defendant Phelip Edmund carpenter 600293 600293 Phelip, Edmund, of Westmyll, carpenter 1
5410684 2478138 2478138 defendant Olyver Adam clerk 600293 600293 Olyver, Adam, of Westmyll, clerk 0
5542876 2517889 2517889 defendant Hamond John, junior yeoman 600293 600293 Hamond, John, junior, of Westmyll, yeoman 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);