names

74 rows where place_id = 592293

✎ 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
3607232 1869927 1869927 defendant Roughey John yeoman 592293 592293 Roughey, John, of Horley, yeoman 1
3611179 1871173 1871173 defendant Chadworth William yeoman 592293 592293 Chadworth, William, of Horley, yeoman 2
3631146 1904564 1904564 defendant Coper Robert husbandman 592293 592293 Coper, Robert, of Horley, husbandman 0
3631148 1904564 1904564 defendant Waterman John husbandman 592293 592293 Waterman, John, of Horley, husbandman 2
3643146 1908295 1908295 defendant Adams John yeoman 592293 592293 Adams, John, of Horley, yeoman 0
3717515 1931765 1931765 defendant Andrewe John husbandman 592293 592293 Andrewe, John, of Horley, husbandman 1
3727385 1934838 1934838 defendant Herte John husbandman 592293 592293 Herte, John, of Horley, husbandman 0
3741071 1939070 1939070 defendant Todde William tanner 592293 592293 Todde, William, of Horley, tanner 0
3741640 1939255 1939255 defendant Lecheford Henry yeoman 592293 592293 Lecheford, Henry, of Horley, yeoman 1
3741642 1939255 1939255 defendant Lecheford Alice widow 592293 592293 Lecheford, Alice, of Horley, widow 3
3741647 1939256 1939256 defendant Lecheford Henry yeoman 592293 592293 Lecheford, Henry, of Horley, yeoman 2
3741648 1939256 1939256 defendant Lecheford Henry, senior (legal representative) 592293 592293 Lecheford, Henry, senior, of Horley, yeoman, executrix of 3
3741649 1939256 1939256 defendant Lecheford Alice widow 592293 592293 Lecheford, Alice, of Horley, widow 4
3775875 1950207 1950207 defendant Whyte William yeoman 592293 592293 Whyte, William, of Horley, yeoman 2
3800639 1958113 1958113 plaintiff Lyrthe Christopher merchant of the staple 592293 592293 Lyrthe, Christopher, of Horley, yeoman, merchant of the staple 0
3806695 1959992 1959992 defendant Burstowe Richard tailor 592293 592293 Burstowe, Richard, of Horley, tailor 0
3827692 1966524 1966524 defendant Todde William tanner 592293 592293 Todde, William, of Horley, tanner 0
3832095 1967944 1967944 defendant Braye John yeoman 592293 592293 Braye, John, of Horley, yeoman 0
3870020 1980218 1980218 defendant Wakeham Thomas   592293 592293 Wakeham, Thomas, of Horley, bucket maker 2
3899908 1990186 1990186 defendant Wynchester William husbandman 592293 592293 Wynchester, William, of Horley, husbandman 0
3899909 1990186 1990186 defendant Venshe James husbandman 592293 592293 Venshe, James, of Horley, husbandman 1
3899910 1990186 1990186 defendant Gyles Simon husbandman 592293 592293 Gyles, Simon, of Horley, husbandman 2
3899912 1990187 1990187 defendant Wynchester William husbandman 592293 592293 Wynchester, William, of Horley, husbandman 0
3899913 1990187 1990187 defendant Venshe James husbandman 592293 592293 Venshe, James, of Horley, husbandman 1
3899914 1990187 1990187 defendant Gyles Simon husbandman 592293 592293 Gyles, Simon, of Horley, husbandman 2
4309542 2133497 2133497 defendant Woodman Robert yeoman 592293 592293 Woodman, Robert, of Horley, yeoman 0
4312774 2134598 2134598 defendant Bristowe William yeoman 592293 592293 Bristowe, William, of Horley, yeoman 0
4313519 2134836 2134836 defendant Woodman Richard yeoman 592293 592293 Woodman, Richard, of Horley, yeoman 0
4322245 2137855 2137855 defendant Jeale or Geale John husbandman 592293 592293 Jeale or Geale, John, of Horley, husbandman 1
4322248 2137856 2137856 defendant Killycke Richard yeoman 592293 592293 Killycke, Richard, of Horley, yeoman 1
4330021 2140344 2140344 defendant Woodman Robert yeoman 592293 592293 Woodman, Robert, of Horley, yeoman 1
4419195 2170877 2170877 defendant atte Mulne John   592293 592293 atte Mulne, John, of Horley 0
4463237 2189197 2189197 defendant atte Crosse William   592293 592293 atte Crosse, William, of Horley 1
4630010 2240306 2240306 defendant Webbe William   592293 592293 Webbe, William, of Horley 5
4630011 2240306 2240306 defendant Takell John   592293 592293 Takell, John, of Horley 6
4657461 2248225 2248225 defendant Jurdan William yeoman 592293 592293 Jurdan, William, of Horley, yeoman 0
4685396 2261028 2261028 defendant Gryvell Richard gent 592293 592293 Gryvell, Richard, of Horley, gent 0
4685397 2261028 2261028 defendant Perysson Richard yeoman 592293 592293 Perysson, Richard, of Horley, yeoman 1
4685398 2261028 2261028 defendant Rychard-servant Grevyll Nicholas yeoman 592293 592293 Rychard-servant Grevyll, Nicholas, of Horley, yeoman 2
4717656 2270857 2270857 defendant Hychecokes Nicholas   592293 592293 Hychecokes, Nicholas, of Horley, servant 0
4739900 2277557 2277557 defendant Dyker John husbandman 592293 592293 Dyker, John, of Horley, husbandman 0
4765819 2285310 2285310 defendant London Thomas husbandman 592293 592293 London, Thomas, of Horley, husbandman 1
4775961 2288484 2288484 defendant London Thomas husbandman 592293 592293 London, Thomas, of Horley, husbandman 0
4812807 2300123 2300123 defendant Byflete John husbandman 592293 592293 Byflete, John, of Horley, husbandman 0
5273198 2437232 2437232 plaintiff Malyns Robert   592293 592293 Malyns, Robert, of Horley 0
5277262 2438428 2438428 defendant Walker Thomas laborer 592293 592293 Walker, Thomas, of Horley, laborer 1
5309153 2447776 2447776 defendant Burstowe John husbandman 592293 592293 Burstowe, John, of Horley, husbandman 1
5351037 2460431 2460431 defendant Stapilherste John yeoman 592293 592293 Stapilherste, John, of Horley, yeoman 1
5356906 2462223 2462223 defendant Weygo John husbandman 592293 592293 Weygo, John, of Horley, husbandman 2
5365115 2464761 2464761 defendant Ewyk Thomas husbandman 592293 592293 Ewyk, Thomas, of Horley, husbandman 0
5390193 2472257 2472257 defendant Malyn Thomas husbandman 592293 592293 Malyn, Thomas, of Horley, husbandman 1
5409143 2477704 2477704 defendant Eweyk Thomas husbandman 592293 592293 Eweyk, Thomas, of Horley, husbandman 0
5421241 2481285 2481285 defendant Ewyk Thomas husbandman 592293 592293 Ewyk, Thomas, of Horley, husbandman 2
5432601 2484719 2484719 defendant Malyns William husbandman 592293 592293 Malyns, William, of Horley, husbandman 1
5432602 2484719 2484719 defendant Malyns Richard husbandman 592293 592293 Malyns, Richard, of Horley, husbandman 2
5437878 2486262 2486262 defendant Rounde John husbandman 592293 592293 Rounde, John, of Horley, husbandman 0
5440473 2487053 2487053 defendant Ewyk Thomas husbandman 592293 592293 Ewyk, Thomas, of Horley, husbandman 2
5442100 2487555 2487555 defendant Chadworth William husbandman 592293 592293 Chadworth, William, of Horley, husbandman 2
5442107 2487556 2487556 defendant Chudworth William husbandman 592293 592293 Chudworth, William, of Horley, husbandman 2
5448675 2489502 2489502 defendant Malyns William   592293 592293 Malyns, William, of Horley 1
5448676 2489502 2489502 defendant Malyns Richard husbandman 592293 592293 Malyns, Richard, of Horley, husbandman 2
5448680 2489503 2489503 defendant Malyns William husbandman 592293 592293 Malyns, William, of Horley, husbandman 1
5448681 2489503 2489503 defendant Malyns Richard husbandman 592293 592293 Malyns, Richard, of Horley, husbandman 2
5452027 2490487 2490487 defendant Rounde John   592293 592293 Rounde, John, of Horley 0
5452029 2490488 2490488 defendant Rounde John husbandman 592293 592293 Rounde, John, of Horley, husbandman 0
5453421 2490913 2490913 defendant Flete John husbandman 592293 592293 Flete, John, of Horley, husbandman 0
5454840 2491366 2491366 defendant Chadworth Robert husbandman 592293 592293 Chadworth, Robert, of Horley, husbandman 1
5454841 2491366 2491366 defendant Chadworth William husbandman 592293 592293 Chadworth, William, of Horley, husbandman 2
5454842 2491366 2491366 defendant Chadworth John husbandman 592293 592293 Chadworth, John, of Horley, husbandman 3
5517793 2510408 2510408 defendant Grenewyche John yeoman 592293 592293 Grenewyche, John, of Horley, yeoman 0
5530929 2514190 2514190 defendant Humfrey Henry   592293 592293 Humfrey, Henry, of Horley, pedlar 1
5530941 2514194 2514194 defendant Heth John laborer 592293 592293 Heth, John, of Horley, laborer 0
5578090 2528218 2528218 defendant Brodfeld John carpenter 592293 592293 Brodfeld, John, of Horley, carpenter 1
5608616 2537594 2537594 defendant Ewyk Thomas husbandman 592293 592293 Ewyk, Thomas, of Horley, husbandman 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);