names

30 rows where place_id = 756650

✎ 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
4439467 2181607 2181607 plaintiff Bakeman William   756650 756650 Bakeman, William, of Henle on Thames 0
4439469 2181608 2181608 plaintiff Bakeman William   756650 756650 Bakeman, William, of Henle on Thames 0
4459517 2188031 2188031 defendant Fisshere Adam   756650 756650 Fisshere, Adam, of Henle on Thames 0
4459544 2188039 2188039 defendant Fisshere Adam   756650 756650 Fisshere, Adam, of Henle on Thames 0
4459575 2188048 2188048 defendant Fysshere Adam   756650 756650 Fysshere, Adam, of Henle on Thames 0
4496808 2199669 2199669 defendant Pert Thomas   756650 756650 Pert, Thomas, of Henle on Thames 0
4508121 2203014 2203014 defendant Willy Nicholas   756650 756650 Willy, Nicholas, of Henle on Thames 0
4511456 2204028 2204028 plaintiff Berkeweye Katherine   756650 756650 Berkeweye, Katherine, of Henle on Thames, formerly wife of John 0
4572943 2223075 2223075 defendant Okys John   756650 756650 Okys, John, of Henle on Thames 1
4652999 2246869 2246869 defendant More William husbandman 756650 756650 More, William, of Henle on Thames, husbandman 1
4674032 2257489 2257489 defendant Tuggewode Richard cardmaker 756650 756650 Tuggewode, Richard, of Henle on Thames, cardmaker 0
4676023 2258112 2258112 plaintiff Fysshere Walter   756650 756650 Fysshere, Walter, of Henle on Thames 0
4720687 2271804 2271804 defendant Gratele John chapman 756650 756650 Gratele, John, of Henle on Thames, chapman 0
4786429 2291801 2291801 plaintiff Fyschere Walter   756650 756650 Fyschere, Walter, of Henle on Thames 0
4791492 2293433 2293433 defendant Burton William yeoman 756650 756650 Burton, William, of Henle on Thames, yeoman 2
4823073 2303301 2303301 plaintiff Spyre Thomas   756650 756650 Spyre, Thomas, of Henle on Thames, on his own account 0
4862810 2315352 2315352 defendant Tanner Edmund butcher 756650 756650 Tanner, Edmund, of Henle on Thames, butcher 0
4869282 2317360 2317360 defendant Boys Robert husbandman 756650 756650 Boys, Robert, of Henle on Thames, husbandman 0
4869283 2317360 2317360 defendant Cardemaker John   756650 756650 Cardemaker, John, of Henle on Thames, card maker 1
4869284 2317360 2317360 defendant Beelee John laborer 756650 756650 Beelee, John, of Henle on Thames, laborer 2
4869380 2317392 2317392 defendant Man Thomas carpenter 756650 756650 Man, Thomas, of Henle on Thames, carpenter 0
4878223 2320140 2320140 defendant Newenham Richard scrivener 756650 756650 Newenham, Richard, of Henle on Thames, scrivener 0
4892901 2324512 2324512 defendant Somer William husbandman 756650 756650 Somer, William, of Henle on Thames, husbandman 0
4905484 2328311 2328311 defendant Hertilpole John yeoman 756650 756650 Hertilpole, John, of Henle on Thames, yeoman 0
4907420 2328882 2328882 plaintiff Sare Agnes   756650 756650 Sare, Agnes, of Henle on Thames 1
4948359 2341470 2341470 plaintiff Man Thomas carpenter 756650 756650 Man, Thomas, of Henle on Thames, carpenter 0
4948360 2341470 2341470 defendant Archer Thomas carpenter 756650 756650 Archer, Thomas, of Henle on Thames, carpenter 0
5090052 2383461 2383461 defendant atte Lee John smith 756650 756650 atte Lee, John, of Henle on Thames, smith 0
5098577 2386017 2386017 defendant Prat John, senior hosteler 756650 756650 Prat, John, senior, of Henle on Thames, hosteler 0
5268562 2435925 2435925 defendant Bodyngton William fishmonger 756650 756650 Bodyngton, William, of Henle on Thames, fishmonger 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);