names

25 rows where place_id = 588234

✎ 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
3593804 1865701 1865701 defendant Dunward Thomas tailor 588234 588234 Dunward, Thomas, of Kynges Sutton, tailor 0
3661650 1913921 1913921 defendant Robyns John husbandman 588234 588234 Robyns, John, of Kynges Sutton, husbandman 2
3661652 1913921 1913921 defendant Kyngle Henry husbandman 588234 588234 Kyngle, Henry, of Kynges Sutton, husbandman 4
3772962 1949245 1949245 defendant Peerson Thomas butcher 588234 588234 Peerson, Thomas, of Kynges Sutton, butcher 0
4417521 2170368 2170368 defendant Phippes Walter   588234 588234 Phippes, Walter, of Kynges Sutton 0
4431585 2174648 2174648 plaintiff Brembre Thomas de   588234 588234 Brembre, Thomas de, of Kynges Sutton, prebendary in the church of the BM, in Lincoln 0
4468538 2190828 2190828 plaintiff Beaufort Henry   588234 588234 Beaufort, Henry, of Kynges Sutton, prebendary, in the Cathedral of Lincoln, 0
4483159 2195429 2195429 defendant Haynes Walter   588234 588234 Haynes, Walter, of Kynges Sutton 0
4607185 2233362 2233362 plaintiff Bedeford Richard (legal representative) 588234 588234 Bedeford, Richard, of Kynges Sutton, master alias canon of the new college of the BM, in Leicester, executor of 0
4607188 2233363 2233363 plaintiff Bedeford Richard (legal representative) 588234 588234 Bedeford, Richard, of Kynges Sutton, master alias canon of the new college of the BM, in Leicester, executor of 0
4650695 2246220 2246220 defendant Hope John de   588234 588234 Hope, John de, of Kynges Sutton 0
4750450 2280615 2280615 defendant Owayn John carpenter 588234 588234 Owayn, John, of Kynges Sutton, carpenter 0
4776308 2288583 2288583 defendant Owayn John laborer 588234 588234 Owayn, John, of Kynges Sutton, laborer 0
4788191 2292379 2292379 plaintiff Hawkys Richard   588234 588234 Hawkys, Richard, of Kynges Sutton 0
4853243 2312431 2312431 defendant Dorn John husbandman 588234 588234 Dorn, John, of Kynges Sutton, husbandman 0
4859621 2314381 2314381 defendant Hewyn John carpenter 588234 588234 Hewyn, John, of Kynges Sutton, carpenter 1
4865461 2316162 2316162 defendant Huntyngdon William husbandman 588234 588234 Huntyngdon, William, of Kynges Sutton, husbandman 1
4865462 2316162 2316162 defendant Vicarys Henry husbandman 588234 588234 Vicarys, Henry, of Kynges Sutton, husbandman 2
4879732 2320580 2320580 plaintiff Vykery Henry   588234 588234 Vykery, Henry, of Kynges Sutton 0
4884570 2322081 2322081 defendant Heynes John cordwainer 588234 588234 Heynes, John, of Kynges Sutton, cordwainer 0
5114925 2390779 2390779 defendant Averey William gent 588234 588234 Averey, William, of Kynges Sutton, gent 0
5337566 2456307 2456307 defendant Calswey Lawrence husbandman 588234 588234 Calswey, Lawrence, of Kynges Sutton, husbandman 0
5361048 2463481 2463481 defendant Swaby William carpenter 588234 588234 Swaby, William, of Kynges Sutton, carpenter 0
5503752 2506089 2506089 defendant Swayn William yeoman 588234 588234 Swayn, William, of Kynges Sutton, yeoman 1
5592554 2532661 2532661 plaintiff Westall Thomas   588234 588234 Westall, Thomas, of Kynges Sutton 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);