names

30 rows where place_id = 755606

✎ 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
4237410 2108678 2108678 plaintiff Palmes Brian (legal representative) 755606 755606 Palmes, Brian, of Naburn, administrator of 0
4426592 2173127 2173127 plaintiff Paumes Eda   755606 755606 Paumes, Eda, of Naburn, formerly wife of William 0
4429637 2174063 2174063 plaintiff Warton John de   755606 755606 Warton, John de, of Naburn 0
4429980 2174161 2174161 defendant Northfolk John de   755606 755606 Northfolk, John de, of Naburn, son of Thomas 0
4439754 2181709 2181709 defendant Pammes William   755606 755606 Pammes, William, of Naburn 0
4492500 2198342 2198342 defendant Palmes Francis   755606 755606 Palmes, Francis, of Naburn 0
4504006 2201809 2201809 defendant Palmes Francis   755606 755606 Palmes, Francis, of Naburn 1
4504030 2201811 2201811 defendant Chapman Robert   755606 755606 Chapman, Robert, of Naburn 3
4577681 2224525 2224525 defendant Symson John   755606 755606 Symson, John, of Naburn 1
4648427 2245587 2245587 defendant Palmes Alice   755606 755606 Palmes, Alice, of Naburn 0
4648428 2245587 2245587 defendant Custyn Mathew   755606 755606 Custyn, Mathew, of Naburn 1
4739599 2277460 2277460 defendant Nelson Robert yeoman 755606 755606 Nelson, Robert, of Naburn, yeoman 0
4739600 2277460 2277460 defendant Nelson Nicholas husbandman 755606 755606 Nelson, Nicholas, of Naburn, husbandman 1
4747887 2279886 2279886 plaintiff Letter Thomas   755606 755606 Letter, Thomas, of Naburn 0
4754512 2281791 2281791 defendant Nelson Nicholas husbandman 755606 755606 Nelson, Nicholas, of Naburn, husbandman 1
4764787 2284969 2284969 defendant Fulshawe William yeoman 755606 755606 Fulshawe, William, of Naburn, yeoman 1
4788911 2292585 2292585 defendant Fulshawe William yeoman 755606 755606 Fulshawe, William, of Naburn, yeoman 0
4790671 2293169 2293169 defendant Fulshawe William yeoman 755606 755606 Fulshawe, William, of Naburn, yeoman 1
4846046 2310267 2310267 defendant Chapman Nicholas   755606 755606 Chapman, Nicholas, of Naburn, franklin 4
4858513 2314038 2314038 defendant Fulshawe William yeoman 755606 755606 Fulshawe, William, of Naburn, yeoman 0
4898800 2326270 2326270 plaintiff Katerton Richard   755606 755606 Katerton, Richard, of Naburn 0
4914380 2331013 2331013 defendant Carbet John husbandman 755606 755606 Carbet, John, of Naburn, husbandman 0
4914381 2331013 2331013 defendant Striklan Thomas husbandman 755606 755606 Striklan, Thomas, of Naburn, husbandman 1
4924159 2334000 2334000 defendant Wilkynson Thomas husbandman 755606 755606 Wilkynson, Thomas, of Naburn, husbandman 0
4979434 2350804 2350804 defendant Haksop William husbandman 755606 755606 Haksop, William, of Naburn, husbandman 0
4979435 2350804 2350804 defendant Gonsell or Gousell John husbandman 755606 755606 Gonsell or Gousell, John, of Naburn, husbandman 1
5116597 2391287 2391287 defendant Johnson William husbandman 755606 755606 Johnson, William, of Naburn, husbandman 0
5234447 2425667 2425667 defendant Newton William yeoman 755606 755606 Newton, William, of Naburn, yeoman 0
5249818 2430060 2430060 defendant Chapman William yeoman 755606 755606 Chapman, William, of Naburn, yeoman 3
5258178 2432678 2432678 defendant Neweton William husbandman 755606 755606 Neweton, William, of Naburn, husbandman 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);