names

48 rows where place_id = 596897

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626566 1903160 1903160 plaintiff Baker Thomas fuller 596897 596897 Baker, Thomas, of Sonnyng, fuller 0
3626567 1903160 1903160 defendant Stedeman Richard husbandman 596897 596897 Stedeman, Richard, of Sonnyng, husbandman 0
3640984 1907620 1907620 defendant Gregorye Robert husbandman 596897 596897 Gregorye, Robert, of Sonnyng, husbandman 0
3650369 1910491 1910491 defendant Medwyn Thomas husbandman 596897 596897 Medwyn, Thomas, of Sonnyng, husbandman 1
3655326 1911924 1911924 defendant Rose Thomas laborer 596897 596897 Rose, Thomas, of Sonnyng, laborer 0
3686093 1921811 1921811 defendant Rose Thomas laborer 596897 596897 Rose, Thomas, of Sonnyng, laborer 0
3705433 1927987 1927987 defendant Payn John miller 596897 596897 Payn, John, of Sonnyng, miller 0
3714708 1930899 1930899 defendant Rose Thomas laborer 596897 596897 Rose, Thomas, of Sonnyng, laborer 0
3719517 1932368 1932368 defendant Payne John miller 596897 596897 Payne, John, of Sonnyng, miller 0
3744638 1940216 1940216 defendant Pastelowe Henry husbandman 596897 596897 Pastelowe, Henry, of Sonnyng, husbandman 2
3777338 1950656 1950656 defendant Norman Thomas husbandman 596897 596897 Norman, Thomas, of Sonnyng, husbandman 0
3819454 1963969 1963969 defendant Blake Ralph husbandman 596897 596897 Blake, Ralph, of Sonnyng, husbandman 0
3914508 1995194 1995194 defendant Alsee William husbandman 596897 596897 Alsee, William, of Sonnyng, husbandman 0
4004135 2026252 2026252 defendant Wells Stephen yeoman 596897 596897 Wells, Stephen, of Sonnyng, yeoman 0
4208185 2098415 2098415 defendant Curtys John joimer 596897 596897 Curtys, John, of Sonnyng, joimer 2
4593359 2229208 2229208 defendant Wade Stephen   596897 596897 Wade, Stephen, of Sonnyng 0
4603263 2232222 2232222 defendant Wade Stephen   596897 596897 Wade, Stephen, of Sonnyng 0
4603282 2232226 2232226 defendant Wade Stephen   596897 596897 Wade, Stephen, of Sonnyng 0
4653010 2246872 2246872 defendant Wodeward Robert husbandman 596897 596897 Wodeward, Robert, of Sonnyng, husbandman 0
5053010 2372496 2372496 defendant Goldeney Thomas husbandman 596897 596897 Goldeney, Thomas, of Sonnyng, husbandman 0
5092158 2384083 2384083 defendant Gorwey John weaver 596897 596897 Gorwey, John, of Sonnyng, weaver 0
5092159 2384083 2384083 defendant Gorwey Henry husbandman 596897 596897 Gorwey, Henry, of Sonnyng, husbandman 1
5092163 2384084 2384084 defendant Gorwey John weaver 596897 596897 Gorwey, John, of Sonnyng, weaver 0
5092164 2384084 2384084 defendant Horwey Henry husbandman 596897 596897 Horwey, Henry, of Sonnyng, husbandman 1
5126811 2394316 2394316 defendant Doos John clerk 596897 596897 Doos, John, of Sonnyng, clerk 0
5126812 2394316 2394316 defendant Violl (illegible) gent 596897 596897 Violl, ---, of Sonnyng, gent 1
5126813 2394316 2394316 defendant Stedeman John husbandman 596897 596897 Stedeman, John, of Sonnyng, husbandman 2
5126814 2394316 2394316 defendant Yoman William yeoman 596897 596897 Yoman, William, of Sonnyng, yeoman 3
5145505 2399830 2399830 defendant Doos John clerk 596897 596897 Doos, John, of Sonnyng, clerk 0
5145506 2399830 2399830 defendant Violl John gent 596897 596897 Violl, John, of Sonnyng, gent 1
5145507 2399830 2399830 defendant Stedeman John husbandman 596897 596897 Stedeman, John, of Sonnyng, husbandman 2
5145508 2399830 2399830 defendant Yeoman William yeoman 596897 596897 Yeoman, William, of Sonnyng, yeoman 3
5165910 2405775 2405775 defendant Doos John clerk 596897 596897 Doos, John, of Sonnyng, clerk 0
5165911 2405775 2405775 defendant Violl John gent 596897 596897 Violl, John, of Sonnyng, gent 1
5165912 2405775 2405775 defendant Stedeman John husbandman 596897 596897 Stedeman, John, of Sonnyng, husbandman 2
5165913 2405775 2405775 defendant Yoman William yeoman 596897 596897 Yoman, William, of Sonnyng, yeoman 3
5316970 2450158 2450158 defendant Prudde William gent 596897 596897 Prudde, William, of Sonnyng, gent 1
5335558 2455707 2455707 defendant Hille Robert tailor 596897 596897 Hille, Robert, of Sonnyng, tailor 2
5394749 2473562 2473562 defendant Est Edward butcher 596897 596897 Est, Edward, of Sonnyng, butcher 0
5414076 2479145 2479145 defendant Est Edward butcher 596897 596897 Est, Edward, of Sonnyng, butcher 0
5420195 2480958 2480958 defendant Est Edward butcher 596897 596897 Est, Edward, of Sonnyng, butcher 1
5421448 2481350 2481350 defendant Est Edward butcher 596897 596897 Est, Edward, of Sonnyng, butcher 0
5438949 2486570 2486570 defendant Est Edward butcher 596897 596897 Est, Edward, of Sonnyng, butcher 1
5476325 2497922 2497922 defendant Est Edward butcher 596897 596897 Est, Edward, of Sonnyng, butcher 0
5505776 2506726 2506726 defendant Holy Stephen husbandman 596897 596897 Holy, Stephen, of Sonnyng, husbandman 0
5522915 2511997 2511997 defendant Bemant John husbandman 596897 596897 Bemant, John, of Sonnyng, husbandman 2
5533060 2514882 2514882 defendant Rokes John gent 596897 596897 Rokes, John, of Sonnyng, gent 1
5585425 2530510 2530510 plaintiff Hyde Thomas (legal representative) 596897 596897 Hyde, Thomas, of Sonnyng, gent, executors of 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);