names

30 rows where place_id = 633037

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3810351 1961128 1961128 defendant Smalley Robert husbandman 633037 633037 Smalley, Robert, of Candelesby, husbandman 0
4729507 2274441 2274441 defendant Hede Alan husbandman 633037 633037 Hede, Alan, of Candelesby, husbandman 0
4742779 2278395 2278395 defendant Candelesby Robert milner 633037 633037 Candelesby, Robert, of Candelesby, milner 0
4750689 2280689 2280689 defendant Chapman William husbandman 633037 633037 Chapman, William, of Candelesby, husbandman 3
4887936 2323036 2323036 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 0
4961273 2345340 2345340 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 0
4987749 2353300 2353300 defendant Meweson William yeoman 633037 633037 Meweson, William, of Candelesby, yeoman 4
4987751 2353300 2353300 defendant Meweson John yeoman 633037 633037 Meweson, John,of Candelesby, yeoman 6
4987752 2353300 2353300 defendant Meweson Simon yeoman 633037 633037 Meweson, Simon, of Candelesby, yeoman 7
4993894 2355043 2355043 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 0
4993895 2355043 2355043 defendant Moweson John   633037 633037 Moweson, John, of Candelesby, yeoman, son & heir of William 1
5002021 2357492 2357492 defendant atte Hall William ner dryver 633037 633037 atte Hall, William, of Candelesby, ner dryver 1
5009894 2359768 2359768 defendant Halle William drover 633037 633037 Halle, William, of Candelesby, drover 3
5073605 2378589 2378589 defendant Hall William clerk 633037 633037 Hall, William, of Candelesby, clerk 0
5085898 2382265 2382265 defendant Hall William clerk 633037 633037 Hall, William, of Candelesby, clerk 1
5129408 2395089 2395089 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 2
5139425 2398018 2398018 defendant Colet Robert yeoman 633037 633037 Colet, Robert, of Candelesby, yeoman 2
5148702 2400745 2400745 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 2
5160407 2404136 2404136 defendant Claxby Thomas clerk & parson 633037 633037 Claxby, Thomas, of Candelesby, clerk & parson 0
5160408 2404136 2404136 defendant Mason Simon yeoman 633037 633037 Mason, Simon, of Candelesby, yeoman 1
5167910 2406327 2406327 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 2
5175214 2408444 2408444 defendant Claxby Thomas clerk & parson 633037 633037 Claxby, Thomas, of Candelesby, clerk & parson 0
5175215 2408444 2408444 defendant Mason Simon yeoman 633037 633037 Mason, Simon, of Candelesby, yeoman 1
5183609 2410942 2410942 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 1
5187445 2412049 2412049 defendant Hall William clerk 633037 633037 Hall, William, of Candelesby, clerk 4
5203926 2416900 2416900 defendant Meweson William husbandman 633037 633037 Meweson, William, of Candelesby, husbandman 1
5205488 2417355 2417355 defendant Hale William clerk 633037 633037 Hale, William, of Candelesby, clerk 4
5228022 2423805 2423805 defendant Hall William husbandman 633037 633037 Hall, William, of Candelesby, husbandman 9
5488606 2501476 2501476 defendant Roper Richard husbandman 633037 633037 Roper, Richard, of Candelesby, husbandman 0
5488607 2501476 2501476 defendant Wilkynson John husbandman 633037 633037 Wilkynson, John, of Candelesby, husbandman 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);