names

30 rows where place_id = 611865

✎ 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
3690421 1923169 1923169 defendant Hamon William yeoman 611865 611865 Hamon, William, of St John, Isle of Thanet, yeoman 2
3693995 1924323 1924323 defendant Hamond William yeoman 611865 611865 Hamond, William, of St John, Isle of Thanet, yeoman 0
3708249 1928874 1928874 defendant Hamond William yeoman 611865 611865 Hamond, William, of St John, Isle of Thanet, yeoman 0
3738929 1938381 1938381 plaintiff Havejoy William   611865 611865 Havejoy, William, of St John, Isle of Thanet 1
3747815 1941237 1941237 defendant Lyncoln Thomas yeoman 611865 611865 Lyncoln, Thomas, of St John, Isle of Thanet, yeoman 0
3800273 1958007 1958007 defendant Wylshyer Clement husbandman 611865 611865 Wylshyer, Clement, of St John, Isle of Thanet, husbandman 0
3863877 1978092 1978092 defendant Beke John husbandman 611865 611865 Beke, John, of St John, Isle of Thanet, husbandman 1
4003702 2026090 2026090 defendant Stocke Robert yeoman 611865 611865 Stocke, Robert, of St John, Isle of Thanet, yeoman 1
4075209 2051439 2051439 defendant Bigg John chapman 611865 611865 Bigg, John, of St John, Isle of Thanet, chapman 1
4161132 2081968 2081968 defendant Rowe John husbandman 611865 611865 Rowe, John, of St John, Isle of Thanet, husbandman 0
4732376 2275305 2275305 plaintiff Panter Reginald (legal representative) 611865 611865 Panter, Reginald, of St John, Isle of Thanet, formerly vicar, executor of 0
4884518 2322063 2322063 plaintiff Daundelyon John   611865 611865 Daundelyon, John, of St John, Isle of Thanet 0
4904512 2328020 2328020 plaintiff Daundelyon John   611865 611865 Daundelyon, John, of St John, Isle of Thanet 0
4905691 2328380 2328380 defendant Gylot Robert husbandman 611865 611865 Gylot, Robert, of St John, Isle of Thanet, husbandman 1
4906874 2328734 2328734 defendant Shepherd Richard   611865 611865 Shepherd, Richard, of St John, Isle of Thanet, shepherd 4
4907200 2328816 2328816 defendant Lauerence John   611865 611865 Lauerence, John, of St John, Isle of Thanet 2
4907267 2328837 2328837 defendant James John husbandman 611865 611865 James, John, of St John, Isle of Thanet, husbandman 0
4907268 2328837 2328837 defendant Laurence John husbandman 611865 611865 Laurence, John, of St John, Isle of Thanet, husbandman 1
4940139 2338946 2338946 plaintiff Daundelyon John   611865 611865 Daundelyon, John, of St John, Isle of Thanet 0
4940141 2338947 2338947 plaintiff Daundelyon John gent 611865 611865 Daundelyon, John, of St John, Isle of Thanet, gent 0
4974070 2349207 2349207 defendant Astyn Stephen butcher 611865 611865 Astyn, Stephen, of St John, Isle of Thanet, butcher 0
4976768 2350005 2350005 defendant Birkyn John clerk 611865 611865 Birkyn, John, of St John, Isle of Thanet, clerk 0
5030891 2365906 2365906 defendant Letherer John husbandman 611865 611865 Letherer, John, of St John, Isle of Thanet, husbandman 0
5032463 2366378 2366378 defendant Coward John butcher 611865 611865 Coward, John, of St John, Isle of Thanet, butcher 2
5323488 2452103 2452103 defendant Bedell Richard shipman 611865 611865 Bedell, Richard, of St John, Isle of Thanet, shipman 0
5332196 2454704 2454704 defendant Lyon John laborer 611865 611865 Lyon, John, of St John, Isle of Thanet, laborer 0
5351736 2460642 2460642 defendant Richardson John cordwainer 611865 611865 Richardson, John, of St John, Isle of Thanet, cordwainer 0
5435051 2485414 2485414 defendant Lyon Christopher husbandman 611865 611865 Lyon, Christopher, of St John, Isle of Thanet, husbandman 0
5477661 2498337 2498337 defendant Sayer John husbandman 611865 611865 (Sayer, John, of St John, Isle of Thanet, husbandman 1
5635840 2555166 2555166 defendant Salmon John fisher 611865 611865 Salmon, John, of St John, Isle of Thanet, fisher 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);