names

54 rows where place_id = 591891

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605901 1869508 1869508 defendant Bonde Henry husbandman 591891 591891 Bonde, Henry, of Colney, husbandman 4
3607238 1869929 1869929 defendant Melton Edmund gent 591891 591891 Melton, Edmund, of Colney, gent 0
3610805 1871045 1871045 defendant Bylney Thomas husbandman 591891 591891 Bylney, Thomas, of Colney, husbandman 1
3615129 1872377 1872377 defendant Cropthorn alias Man John tailor 591891 591891 Cropthorn alias Man, John, of Colney, tailor 0
3623680 1874938 1874938 defendant Melton Ellen widow 591891 591891 Melton, Ellen, of Colney, widow 0
3637350 1906485 1906485 defendant White Richard husbandman 591891 591891 White, Richard, of Colney, husbandman 1
3649702 1910280 1910280 defendant Whyte Richard innholder 591891 591891 Whyte, Richard, of Colney, innholder 1
3666702 1915533 1915533 defendant Aleyn Edmund clerk 591891 591891 Aleyn, Edmund, of Colney, clerk 0
3742238 1939441 1939441 defendant Duke Thomas laborer 591891 591891 Duke, Thomas, of Colney, laborer 0
3742239 1939441 1939441 defendant Hemmyng Nicholas husbandman 591891 591891 Hemmyng, Nicholas, of Colney, husbandman 1
3747178 1941036 1941036 defendant Hemmyng Nicholas husbandman 591891 591891 Hemmyng, Nicholas, of Colney, husbandman 0
3790610 1954886 1954886 defendant Bowde Alice   591891 591891 Bowde, Alice, of Colney, widow of Bowde, John, senior, of Colney 1
3791618 1955219 1955219 defendant Dowsyng Richard husbandman 591891 591891 Dowsyng, Richard, of Colney, husbandman 0
3812140 1961709 1961709 defendant Duke Thomas husbandman 591891 591891 Duke, Thomas, of Colney, husbandman 1
3870872 1980510 1980510 defendant Baxster William husbandman 591891 591891 Baxster, William, of Colney, husbandman 0
3888187 1986303 1986303 defendant Hemmyng Nicholas husbandman 591891 591891 Hemmyng, Nicholas, of Colney, husbandman 0
3890203 1986965 1986965 defendant Downyng Robert husbandman 591891 591891 Downyng, Robert, of Colney, husbandman 0
3890204 1986965 1986965 defendant Downyng John laborer 591891 591891 Downyng, John, of Colney, laborer 1
3890205 1986965 1986965 defendant Downyng Richard laborer 591891 591891 Downyng, Richard, of Colney, laborer 2
3903611 1991439 1991439 defendant Johnson Robert husbandman 591891 591891 Johnson, Robert, of Colney, husbandman 1
3905680 1992175 1992175 defendant Johnson Robert husbandman 591891 591891 Johnson, Robert, of Colney, husbandman 0
3910525 1993838 1993838 defendant Johnson Robert husbandman 591891 591891 Johnson, Robert, of Colney, husbandman 0
4091003 2057072 2057072 defendant Hemyng Thomas husbandman 591891 591891 Hemyng, Thomas, of Colney, husbandman 0
4095827 2058841 2058841 defendant Warcope James clerk 591891 591891 Warcope, James, of Colney, clerk 0
4095830 2058842 2058842 defendant Warcope James clerk 591891 591891 Warcope, James, of Colney, clerk 0
4256153 2115039 2115039 defendant Bawdes Edmund husbandman 591891 591891 Bawdes, Edmund, of Colney, husbandman 0
4382564 2158876 2158876 defendant Knowles Marmaduke   591891 591891 Knowles, Marmaduke, of Colney, felt maker 2
4625831 2239031 2239031 defendant Frere Richard   591891 591891 Frere, Richard, of Colney 0
4648364 2245571 2245571 defendant Frere Richard   591891 591891 Frere, Richard, of Colney 3
4721952 2272197 2272197 plaintiff Launde Robert   591891 591891 Launde, Robert, of Colney 2
4742892 2278430 2278430 plaintiff Launde Robert   591891 591891 Launde, Robert, of Colney 2
4768811 2286223 2286223 defendant Brook Roger fuller 591891 591891 Brook, Roger, of Colney, fuller 1
4770944 2286892 2286892 defendant Brook Roger fuller 591891 591891 Brook, Roger, of Colney, fuller 0
4779180 2289462 2289462 defendant Hadley William clothier 591891 591891 Hadley, William, of Colney, clothier 4
4798121 2295604 2295604 defendant Amy William husbandman 591891 591891 Amy, William, of Colney, husbandman 0
4798320 2295661 2295661 defendant Millere Roger yeoman 591891 591891 Millere, Roger, of Colney, yeoman 5
4875543 2319304 2319304 defendant Smyth Richard smith 591891 591891 Smyth, Richard, of Colney, smith 0
4885547 2322359 2322359 defendant Legge John, junior husbandman 591891 591891 Legge, John, junior, of Colney, husbandman 0
4904125 2327902 2327902 defendant Legge Richard carter 591891 591891 Legge, Richard, of Colney, carter 1
4905181 2328218 2328218 defendant Legge John, junior husbandman 591891 591891 Legge, John, junior, of Colney, husbandman 0
4975835 2349737 2349737 defendant Sperhauk Thomas butcher 591891 591891 Sperhauk, Thomas, of Colney, butcher 1
5075219 2379079 2379079 defendant Bowede Henry yeoman 591891 591891 Bowede, Henry, of Colney, yeoman 2
5075220 2379079 2379079 defendant Sperhauk Thomas husbandman 591891 591891 Sperhauk, Thomas, of Colney, husbandman 3
5175509 2408518 2408518 defendant Moncaster Edward husbandman 591891 591891 Moncaster, Edward, of Colney, husbandman 27
5191041 2413123 2413123 defendant Hemmyng Thomas husbandman 591891 591891 Hemmyng, Thomas, of Colney, husbandman 1
5207203 2417847 2417847 defendant Hemmyng Thomas husbandman 591891 591891 Hemmyng, Thomas, of Colney, husbandman 1
5207823 2418030 2418030 defendant Sperhauke Thomas husbandman 591891 591891 Sperhauke, Thomas, of Colney, husbandman 0
5358213 2462625 2462625 defendant Frere William husbandman 591891 591891 Frere, William, of Colney, husbandman 0
5361096 2463497 2463497 defendant Bowde Henry yeoman 591891 591891 Bowde, Henry, of Colney, yeoman 3
5382440 2470036 2470036 defendant Love Robert butcher 591891 591891 Love, Robert, of Colney, butcher 4
5392952 2473053 2473053 defendant Love Robert butcher 591891 591891 Love, Robert, of Colney, butcher 3
5420873 2481171 2481171 defendant Love Robert husbandman 591891 591891 Love, Robert, of Colney, husbandman 3
5430683 2484116 2484116 defendant Manne John husbandman 591891 591891 Manne, John, of Colney, husbandman 1
5503288 2505938 2505938 defendant Bowede Henry husbandman 591891 591891 Bowede, Henry, of Colney, 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);