names

85 rows where place_id = 591052

✎ 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
3603152 1868651 1868651 defendant Turner William yeoman 591052 591052 Turner, William, of Barnet, Herts, yeoman 0
3616225 1872716 1872716 defendant Burton John innholder 591052 591052 Burton, John, of Barnet, Herts, innholder 0
3621631 1874304 1874304 defendant Necols Robert yeoman 591052 591052 Necols, Robert, of Barnet, Herts, yeoman 1
3643716 1908462 1908462 plaintiff Daryngton William armorer 591052 591052 Daryngton, William, of Barnet, Herts, innholder, alias of London, armorer 0
3665123 1915041 1915041 defendant Durant Thomas gent 591052 591052 Durant, Thomas, of Barnet, Herts, gent 0
3665770 1915238 1915238 defendant Edwardes William butcher 591052 591052 Edwardes, William, of Barnet, Herts, butcher 2
3683024 1920803 1920803 defendant Edward William innholder 591052 591052 Edward, William, of Barnet, Herts, innholder 0
3683026 1920804 1920804 defendant Edward William innholder 591052 591052 Edward, William, of Barnet, Herts, innholder 0
3708586 1928985 1928985 defendant Warde William (legal representative) 591052 591052 Warde, William, of Barnet, Herts, yeoman, executrix of 1
3765234 1946792 1946792 defendant Pynyon William smith 591052 591052 Pynyon, William, of Barnet, Herts, smith 0
3855234 1975270 1975270 defendant Edwardes William butcher 591052 591052 Edwardes, William, of Barnet, Herts, butcher 0
3857747 1976061 1976061 defendant Gardener Richard gent 591052 591052 Gardener, Richard, of Barnet, Herts, gent 0
3869383 1979998 1979998 defendant Edwardes William butcher 591052 591052 Edwardes, William, of Barnet, Herts, butcher 0
4144098 2076097 2076097 defendant Dawson Thomas baker 591052 591052 Dawson, Thomas, of Barnet, Herts, baker 1
4393800 2162529 2162529 defendant Bighton Thomas Innholder 591052 591052 Bighton, Thomas, of Barnet, herts, Innholder 1
4554443 2217320 2217320 defendant Belton John   591052 591052 Belton, John, of Barnet, Herts 2
4566514 2221095 2221095 defendant Belton John   591052 591052 Belton, John, of Barnet, Herts 1
4570039 2222202 2222202 defendant Langford John   591052 591052 Langford, John, of Barnet, Herts 0
4703771 2266560 2266560 defendant Carbonell William yeoman 591052 591052 Carbonell, William, of Barnet, Herts, yeoman 0
4703777 2266561 2266561 defendant Carbonell William yeoman 591052 591052 Carbonell, William, of Barnet, Herts, yeoman 0
4723034 2272514 2272514 defendant Craven John husbandman 591052 591052 Craven, John, of Barnet, Herts, husbandman 0
4730105 2274616 2274616 defendant Mudsprot Henry tanner 591052 591052 Mudsprot, Henry, of Barnet, Herts, tanner 0
4747625 2279814 2279814 plaintiff Langford John, senior   591052 591052 Langford, John, senior, of Barnet, Herts, on his own account 0
4748153 2279970 2279970 defendant Mudsprot Henry tanner 591052 591052 Mudsprot, Henry, of Barnet, Herts, tanner 0
4751069 2280796 2280796 defendant Redhede William maltman 591052 591052 Redhede, William, of Barnet, Herts, maltman 2
4797875 2295516 2295516 plaintiff Stalworth William esq 591052 591052 Stalworth, William, of Barnet, Herts, esq 0
4797877 2295517 2295517 plaintiff Stalworth William esq 591052 591052 Stalworth, William, of Barnet, Herts, esq 0
4797879 2295518 2295518 plaintiff Stalworth William esq 591052 591052 Stalworth, William, of Barnet, Herts, esq 0
4813397 2300304 2300304 defendant Heron John husbandman 591052 591052 Heron, John, of Barnet, Herts, husbandman 1
4813405 2300306 2300306 defendant Heron John husbandman 591052 591052 Heron, John, of Barnet, Herts, husbandman 1
4843964 2309628 2309628 defendant Spetulman William chapman 591052 591052 Spetulman, William, of Barnet, Herts, chapman 1
4847863 2310817 2310817 defendant Beauchamp Nicholas husbandman 591052 591052 Beauchamp, Nicholas, of Barnet, Herts, husbandman 1
4861478 2314959 2314959 defendant Barbour William barber 591052 591052 Barbour, William, of Barnet, Herts, barber 2
4863015 2315410 2315410 defendant Redehede William maltman 591052 591052 Redehede, William, of Barnet, Herts, maltman 2
4883526 2321762 2321762 defendant Bertelot John wheeler 591052 591052 Bertelot, John, of Barnet, Herts, wheeler 0
4888937 2323325 2323325 defendant Bertelot John wheeler 591052 591052 Bertelot, John, of Barnet, Herts, wheeler 0
4918581 2332328 2332328 defendant Fetirstone Hugh carter 591052 591052 Fetirstone, Hugh, of Barnet, Herts, carter 1
4956556 2343919 2343919 defendant Osbern Henry husbandman 591052 591052 Osbern, Henry, of Barnet, Herts, husbandman 0
4956566 2343920 2343920 defendant Osbern Henry husbandman 591052 591052 Osbern, Henry, of Barnet, Herts, husbandman 0
4958185 2344416 2344416 defendant Priour John butcher 591052 591052 Priour, John, of Barnet, Herts, butcher 0
5003926 2358037 2358037 defendant Preston Richard maltman 591052 591052 Preston, Richard, of Barnet, Herts, maltman 0
5010036 2359803 2359803 defendant Godeman Thomas yeoman 591052 591052 Godeman, Thomas, of Barnet, Herts, yeoman 0
5010038 2359804 2359804 defendant Godeman Thomas yeoman 591052 591052 Godeman, Thomas, of Barnet, Herts, yeoman 0
5023146 2363671 2363671 defendant Wygan Thomas husbandman 591052 591052 Wygan, Thomas, of Barnet, Herts, husbandman 2
5025929 2364478 2364478 defendant Taillour Walter ostler 591052 591052 Taillour, Walter, of Barnet, Herts, ostler 1
5047759 2370945 2370945 defendant Phelip John butcher 591052 591052 Phelip, John, of Barnet, Herts, butcher 0
5068150 2376977 2376977 defendant Tanner Thomas butcher 591052 591052 Tanner, Thomas, of Barnet, Herts, butcher 0
5068790 2377161 2377161 defendant Pappys John collier 591052 591052 Pappys, John, of Barnet, Herts, collier 0
5078427 2380046 2380046 defendant Hardwyn William yeoman 591052 591052 Hardwyn, William, of Barnet, Herts, yeoman 1
5078485 2380062 2380062 defendant Frowyk Henry esq 591052 591052 Frowyk, Henry, of Barnet, Herts, esq 1
5097346 2385654 2385654 plaintiff Taylour Henry barber 591052 591052 Taylour, Henry, of Barnet, Herts, barber 0
5099226 2386201 2386201 defendant Haksalt Thomas husbandman 591052 591052 Haksalt, Thomas, of Barnet, Herts, husbandman 0
5121248 2392647 2392647 defendant Lyon John yeoman 591052 591052 Lyon, John, of Barnet, Herts, yeoman 0
5134161 2396487 2396487 defendant Brooke Robert husbandman 591052 591052 Brooke, Robert, of Barnet, Herts, husbandman 0
5155479 2402761 2402761 defendant Hurre Richard husbandman 591052 591052 Hurre, Richard, of Barnet, Herts, husbandman 0
5156081 2402936 2402936 defendant Dowelond Robert yeoman 591052 591052 Dowelond, Robert, of Barnet, Herts, yeoman 2
5172031 2407535 2407535 defendant Hurre Richard husbandman 591052 591052 Hurre, Richard, of Barnet, Herts, husbandman 0
5172034 2407536 2407536 defendant Hurre Richard husbandman 591052 591052 Hurre, Richard, of Barnet, Herts, husbandman 0
5172403 2407654 2407654 defendant Dowelond Robert yeoman 591052 591052 Dowelond, Robert, of Barnet, Herts, yeoman 2
5190981 2413107 2413107 defendant Hurre Richard husbandman 591052 591052 Hurre, Richard, of Barnet, Herts, husbandman 0
5191828 2413343 2413343 defendant Dowelond Robert yeoman 591052 591052 Dowelond, Robert, of Barnet, Herts, yeoman 2
5207487 2417931 2417931 defendant Dowelond Robert yeoman 591052 591052 Dowelond, Robert, of Barnet, Herts, yeoman 2
5224346 2422795 2422795 plaintiff Preston     591052 591052 Preston, , of Barnet, Herts 0
5224360 2422800 2422800 plaintiff Preston William   591052 591052 Preston, William, of Barnet, Herts 0
5224362 2422801 2422801 plaintiff Preston William   591052 591052 Preston, William, of Barnet, Herts 0
5224365 2422802 2422802 plaintiff Preston William   591052 591052 Preston,William, of Barnet, Herts 0
5228433 2423921 2423921 defendant Kyrkam John yeoman 591052 591052 Kyrkam, John, of Barnet, Herts, yeoman 0
5237871 2426660 2426660 defendant Frowyk Henry esq 591052 591052 Frowyk, Henry, of Barnet, Herts, esq 0
5237876 2426661 2426661 defendant Frowyk Henry esq 591052 591052 Frowyk, Henry, of Barnet, Herts, esq 0
5330140 2454091 2454091 defendant Dryffeld Robert yeoman 591052 591052 Dryffeld, Robert, of Barnet, Herts, yeoman 0
5346612 2459093 2459093 defendant Frowyk Henry esq 591052 591052 Frowyk, Henry, of Barnet, Herts, esq 0
5346614 2459094 2459094 defendant Frowyk Henry esq 591052 591052 Frowyk, Henry, of Barnet, Herts, esq 0
5364303 2464495 2464495 defendant Chanell William yeoman 591052 591052 Chanell, William, of Barnet, Herts, yeoman 4
5364312 2464497 2464497 defendant Chanell or Chavell William yeoman 591052 591052 Chanell or Chavell, William, of Barnet, Herts, yeoman 3
5429661 2483809 2483809 defendant Wodnot John baker 591052 591052 Wodnot, John, of Barnet, Herts, baker 0
5446585 2488867 2488867 defendant Wodnot John baker 591052 591052 Wodnot, John, of Barnet, Herts, baker 0
5465259 2494515 2494515 defendant Gunston John husbandman 591052 591052 Gunston, John, of Barnet, Herts, husbandman 1
5487173 2501060 2501060 defendant Weste Edmund innholder 591052 591052 Weste, Edmund, of Barnet, Herts, innholder 0
5495686 2503606 2503606 defendant West Edmund yeoman 591052 591052 West, Edmund, of Barnet, Herts, yeoman 0
5495692 2503607 2503607 defendant West Edmund yeoman 591052 591052 West, Edmund, of Barnet, Herts, yeoman 0
5495698 2503608 2503608 defendant West Edmund yeoman 591052 591052 West, Edmund, of Barnet, Herts, yeoman 0
5495702 2503609 2503609 defendant West Edmund yeoman 591052 591052 West, Edmund, of Barnet, Herts, yeoman 0
5495962 2503687 2503687 defendant Malblank John courser 591052 591052 Malblank, John, of Barnet, Herts, courser 0
5505888 2506765 2506765 defendant Tayllour Eleanor widow 591052 591052 Tayllour, Eleanor, of Barnet, Herts, widow 2
5566771 2524876 2524876 defendant Daryngton William innholder 591052 591052 Daryngton, William, of Barnet, Herts, innholder 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);