names

31 rows where place_id = 594233

✎ 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
3615181 1872393 1872393 defendant Est Thomas tailor 594233 594233 Est, Thomas, of Havent, tailor 1
3635356 1905852 1905852 defendant Forster William husbandman 594233 594233 Forster, William, of Havent, husbandman 0
3739609 1938603 1938603 defendant Warner Henry gent 594233 594233 Warner, Henry, of Havent, gent 0
4724937 2273092 2273092 defendant Goddessond Almaric fletcher 594233 594233 Goddessond, Almaric, of Havent, fletcher 0
4843348 2309435 2309435 defendant Moraunt Roger   594233 594233 Moraunt, Roger, of Havent, nail maker 1
4892139 2324282 2324282 defendant Goode Edward merchant 594233 594233 Goode, Edward, of Havent, merchant 0
4893032 2324541 2324541 defendant Assheley John yeoman 594233 594233 Assheley, John, of Havent, yeoman 0
4893033 2324541 2324541 defendant Chapman John yeoman 594233 594233 Chapman, John, of Havent, yeoman 1
4893034 2324541 2324541 defendant Powes William yeoman 594233 594233 Powes, William, of Havent, yeoman 2
4893035 2324541 2324541 defendant Bocher Henry yeoman 594233 594233 Bocher, Henry, of Havent, yeoman 3
4916619 2331705 2331705 defendant Gyste John husbandman 594233 594233 Gyste, John, of Havent, husbandman 0
5022883 2363606 2363606 defendant Folye Peter merchant 594233 594233 Folye, Peter, of Havent, merchant 0
5034926 2367073 2367073 defendant Godenowe John tanner 594233 594233 Godenowe, John, of Havent, tanner 3
5046180 2370487 2370487 plaintiff Marchall Thomas   594233 594233 Marchall, Thomas, of Havent, parson 0
5053244 2372573 2372573 defendant Foly John painter 594233 594233 Foly, John, of Havent, painter 0
5082757 2381346 2381346 defendant Foly Peter merchant 594233 594233 Foly, Peter, of Havent, merchant 0
5083953 2381702 2381702 defendant Foly Peter merchant 594233 594233 Foly, Peter, of Havent, merchant 0
5123782 2393415 2393415 defendant Stapilton Richard merchant 594233 594233 Stapilton, Richard, of Havent, merchant 0
5239874 2427238 2427238 defendant Pery William mercer 594233 594233 Pery, William, of Havent, mercer 0
5278791 2438905 2438905 defendant Peryn William laborer 594233 594233 Peryn, William, of Havent, laborer 0
5278792 2438905 2438905 defendant Peryn Thomas laborer 594233 594233 Peryn, Thomas, of Havent, laborer 1
5282520 2439947 2439947 defendant Frampton Thomas yeoman 594233 594233 Frampton, Thomas, of Havent, yeoman 0
5296945 2444100 2444100 defendant Seton John yeoman 594233 594233 Seton, John, of Havent, yeoman 0
5313275 2449006 2449006 defendant Mylle Lawrence ostler 594233 594233 Mylle, Lawrence, of Havent, ostler 4
5373550 2467326 2467326 defendant Taillour Nicholas tailor 594233 594233 Taillour, Nicholas, of Havent, tailor 1
5399239 2474851 2474851 defendant Messanger Agnes widow 594233 594233 Messanger, Agnes, of Havent, widow 3
5410973 2478233 2478233 defendant Simond William cooper 594233 594233 Simond, William, of Havent, cooper 0
5425121 2482476 2482476 defendant Simond William cooper 594233 594233 Simond, William, of Havent, cooper 0
5490426 2502031 2502031 defendant Weldyssh Gregory butcher 594233 594233 Weldyssh, Gregory, of Havent, butcher 0
5533004 2514866 2514866 defendant Clyfton alias Laurence John dyer 594233 594233 Clyfton alias Laurence, John, of Havent, dyer 0
5533392 2514994 2514994 defendant Costwile John husbandman 594233 594233 Costwile, John, of Havent, husbandman 1

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);