names

32 rows where place_id = 586681

✎ 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
3589359 1864313 1864313 defendant Sayton John gent 586681 586681 Sayton, John, of Maydewell, gent 0
3715910 1931261 1931261 defendant Seyton Thomas gent 586681 586681 Seyton, Thomas, of Maydewell, gent 1
3733883 1936845 1936845 defendant Brokes Thomas gent 586681 586681 Brokes, Thomas, of Maydewell, gent 0
3755210 1943582 1943582 defendant Haynes Edward yeoman 586681 586681 Haynes, Edward, of Maydewell, yeoman 0
3761657 1945658 1945658 defendant browes Thomas gent 586681 586681 browes, Thomas, of Maydewell, gent 1
4292870 2127515 2127515 defendant Parsons John husbandman 586681 586681 Parsons, John, of Maydewell, husbandman 0
4520220 2206662 2206662 defendant Taillour Thomas   586681 586681 Taillour, Thomas, of Maydewell 0
4558286 2218534 2218534 plaintiff Longevill John   586681 586681 Longevill, John, of Maydewell 0
4678637 2258923 2258923 defendant Seyton John esq 586681 586681 Seyton, John, of Maydewell, esq 0
4678638 2258923 2258923 defendant Luffenham Robert yeoman 586681 586681 Luffenham, Robert, of Maydewell, yeoman 1
4678639 2258923 2258923 defendant Horne John yeoman 586681 586681 Horne, John, of Maydewell, yeoman 2
4678640 2258923 2258923 defendant Wotton William butcher 586681 586681 Wotton, William, of Maydewell, butcher 3
4704147 2266677 2266677 defendant Seyton John esq 586681 586681 Seyton, John, of Maydewell, esq 0
4704149 2266678 2266678 defendant Seyton John esq 586681 586681 Seyton, John, of Maydewell, esq 0
4704150 2266678 2266678 defendant Laffenham Robert yeoman 586681 586681 Laffenham, Robert, of Maydewell, yeoman 1
4704151 2266678 2266678 defendant Horne John yeoman 586681 586681 Horne, John, of Maydewell, yeoman 2
4704152 2266678 2266678 defendant Wotton William butcher 586681 586681 Wotton, William, of Maydewell, butcher 3
4734680 2276003 2276003 defendant Partrik Thomas   586681 586681 Partrik, Thomas, of Maydewell, servant 0
4734681 2276003 2276003 defendant Whitehed John husbandman 586681 586681 Whitehed, John, of Maydewell, husbandman 1
4734682 2276003 2276003 defendant Saunder John husbandman 586681 586681 Saunder, John, of Maydewell, husbandman 2
4800180 2296231 2296231 defendant Saweselby John butcher 586681 586681 Saweselby, John, of Maydewell, butcher 0
4858722 2314104 2314104 plaintiff Bukby John   586681 586681 Bukby, John, of Maydewell 0
5005813 2358599 2358599 defendant Geffecok John yeoman 586681 586681 Geffecok, John, of Maydewell, yeoman 0
5104690 2387807 2387807 defendant Penne William yeoman 586681 586681 Penne, William, of Maydewell, yeoman 2
5116584 2391281 2391281 defendant Pye Thomas husbandman 586681 586681 Pye, Thomas, of Maydewell, husbandman 3
5206384 2417601 2417601 plaintiff (not given) John rector of Justice 586681 586681 Justice, John, of Maydewell, clerk & rector of the parish church of the BM, with the chapel of St David of Kelmersshe, Lincoln diocese 0
5222735 2422366 2422366 defendant Griffyth Thomas chaplain 586681 586681 Griffyth, Thomas, of Maydewell, chaplain 1
5232781 2425174 2425174 defendant Penne William yeoman 586681 586681 Penne, William, of Maydewell, yeoman 1
5246740 2429208 2429208 defendant Wright Nicholas yeoman 586681 586681 Wright, Nicholas, of Maydewell, yeoman 1
5345611 2458787 2458787 defendant Penne William yeoman 586681 586681 Penne, William, of Maydewell, yeoman 1
5346309 2458987 2458987 defendant Wardon Thomas husbandman 586681 586681 Wardon, Thomas, of Maydewell, husbandman 1
5511832 2508557 2508557 defendant Canell or Cavell William husbandman 586681 586681 Canell or Cavell, William, of Maydewell, 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);