names

35 rows where place_id = 587304

✎ 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
3591028 1864820 1864820 plaintiff Glover Thomas   587304 587304 (Glover, Thomas, of Wallyngford 1
3661267 1913800 1913800 defendant Dene William yeoman 587304 587304 Dene, William, of Wallyngford, yeoman 0
3742624 1939561 1939561 defendant Osbaston Lambert beer brewer 587304 587304 Osbaston, Lambert, of Wallyngford, beer brewer 0
3779794 1951412 1951412 defendant Gaye Thomas yeoman 587304 587304 Gaye, Thomas, of Wallyngford, yeoman 0
3880423 1983708 1983708 plaintiff Polyngton Thomas yeoman 587304 587304 Polyngton, Thomas, of Wallyngford, yeoman 0
3948561 2006557 2006557 defendant Clerke Hugh weaver 587304 587304 Clerke, Hugh, of Wallyngford, weaver 0
4061391 2046478 2046478 defendant Symond Henry yeoman 587304 587304 Symond, Henry, of Wallyngford, yeoman 1
4063801 2047339 2047339 plaintiff Goulder John weaver 587304 587304 Goulder, John, of Wallyngford, weaver 0
4550701 2216163 2216163 plaintiff Denby John   587304 587304 Denby, John, of Wallyngford 0
4550706 2216164 2216164 plaintiff Denby John   587304 587304 Denby, John, of Wallyngford 0
4554755 2217414 2217414 defendant Ildesley John chapman 587304 587304 Ildesley, John, of Wallyngford, chapman 0
4595118 2229729 2229729 defendant Brwode John   587304 587304 Brwode, John, of Wallyngford 0
4595127 2229730 2229730 defendant Bruwode John   587304 587304 Bruwode, John, of Wallyngford 1
4716433 2270458 2270458 plaintiff Coterell John   587304 587304 Coterell, John, of Wallyngford 1
4781210 2290136 2290136 defendant Holand John chapman 587304 587304 Holand, John, of Wallyngford, chapman 0
4792714 2293808 2293808 defendant Mercham alias Chaloner John husbandman 587304 587304 Mercham alias Chaloner, John, of Wallyngford, husbandman 0
4792715 2293808 2293808 defendant Clowede William cordwainer 587304 587304 Clowede, William, of Wallyngford, cordwainer 1
4792716 2293808 2293808 defendant Lane alias Brasier William brasier 587304 587304 Lane alias Brasier, William, of Wallyngford, brasier 2
5251541 2430586 2430586 defendant Gaye William   587304 587304 Gaye, William, of Wallyngford, tallow chandler 0
5267847 2435706 2435706 defendant Fesaunt William chapman 587304 587304 Fesaunt, William, of Wallyngford, chapman 2
5362248 2463854 2463854 defendant Husbond John smith 587304 587304 Husbond, John, of Wallyngford, smith 3
5379341 2469132 2469132 defendant Symondis John husbandman 587304 587304 Symondis, John, of Wallyngford, husbandman 1
5385206 2470845 2470845 defendant Huls William gent 587304 587304 Huls, William, of Wallyngford, gent 0
5387190 2471405 2471405 defendant Glaswas William gent 587304 587304 Glaswas, William, of Wallyngford, gent 0
5395159 2473685 2473685 defendant Dene John   587304 587304 Dene, John, of Wallyngford, inn holder 0
5395171 2473691 2473691 plaintiff a Dene John Alderman 587304 587304 a Dene, John, of Wallyngford, Alderman 0
5395172 2473691 2473691 defendant Massey Henry butcher 587304 587304 Massey, Henry, of Wallyngford, butcher 0
5397298 2474310 2474310 defendant Huls William gent 587304 587304 Huls, William, of Wallyngford, gent 0
5418034 2480320 2480320 defendant Dene John innholder 587304 587304 Dene, John, of Wallyngford, innholder 0
5450707 2490097 2490097 defendant Dene John innholder 587304 587304 Dene, John, of Wallyngford, innholder 0
5496916 2504010 2504010 defendant Weston Henry butcher 587304 587304 Weston, Henry, of Wallyngford, butcher 0
5496917 2504010 2504010 defendant Massey Henry butcher 587304 587304 Massey, Henry, of Wallyngford, butcher 1
5496920 2504010 2504010 defendant Whiteborne Thomas miller 587304 587304 Whiteborne, Thomas, of Wallyngford, miller 4
5603840 2536069 2536069 defendant Gryffyth Thomas clerk 587304 587304 Gryffyth, Thomas, of Wallyngford, clerk 0
5603842 2536070 2536070 defendant Gryffyth Thomas clerk 587304 587304 Gryffyth, Thomas, of Wallyngford, clerk 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);