names

18 rows where place_id = 587962

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592966 1865423 1865423 defendant Holand Robert husbandman 587962 587962 Holand, Robert, of Levesham, husbandman 0
3599114 1867360 1867360 defendant Holand Robert yeoman 587962 587962 Holand, Robert, of Levesham, yeoman 0
3600242 1867723 1867723 defendant Vidill William butcher 587962 587962 Vidill, William, of Levesham, butcher 0
3758036 1944497 1944497 defendant Sterky John yeoman 587962 587962 Sterky, John, of Levesham, yeoman 0
3781002 1951789 1951789 defendant Stevynson Hugh yeoman 587962 587962 Stevynson, Hugh, of Levesham, yeoman 0
3781003 1951789 1951789 defendant Marten Robert glover 587962 587962 Marten, Robert, of Levesham, glover 1
3781004 1951789 1951789 defendant Broker Thomas husbandman 587962 587962 Broker, Thomas, of Levesham, husbandman 2
4604657 2232619 2232619 defendant Uppesall Richard   587962 587962 Uppesall, Richard, of Levesham, parson 1
5397104 2474255 2474255 defendant Combe Isabel   587962 587962 Combe, Isabel, of Levesham, widow, formerly wife of Testator 6
5495652 2503599 2503599 defendant Bedyll Richard husbandman 587962 587962 Bedyll, Richard, of Levesham, husbandman 0
5511701 2508507 2508507 defendant Merston Bernard husbandman 587962 587962 Merston, Bernard, of Levesham, husbandman 1
5516899 2510109 2510109 defendant Johnson Alexander brewer 587962 587962 Johnson, Alexander, of Levesham, brewer 0
5528394 2513420 2513420 defendant Percy Oliver gent 587962 587962 Percy, Oliver, of Levesham, gent 1
5539675 2516890 2516890 defendant Kechell John husbandman 587962 587962 Kechell, John, of Levesham, husbandman 0
5539676 2516890 2516890 defendant Kyng William husbandman 587962 587962 Kyng, William, of Levesham, husbandman 1
5539677 2516890 2516890 defendant Berepyghtell Thomas husbandman 587962 587962 Berepyghtell, Thomas, of Levesham, husbandman 2
5559105 2522624 2522624 defendant Vele William gent 587962 587962 Vele, William, of Levesham, gent 1
5604846 2536383 2536383 defendant Robyns Joan widow 587962 587962 Robyns, Joan, of Levesham, widow, formerly Wyllyams, Joan, of Lewysham, widow 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);