names

98 rows where place_id = 602677

✎ 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
3651248 1910755 1910755 defendant Grenehalgh Thomas husbandman 602677 602677 Grenehalgh, Thomas, of Assheton, husbandman 2
3651249 1910755 1910755 defendant Aurefar Richard husbandman 602677 602677 Aurefar, Richard, of Assheton, husbandman 3
3653601 1911390 1911390 defendant Assheton Gervase clerk 602677 602677 Assheton, Gervase, of Assheton, clerk 10
3669919 1916537 1916537 defendant Shepard John yeoman 602677 602677 Shepard, John, of Assheton, yeoman 1
3669924 1916538 1916538 defendant Shepard John yeoman 602677 602677 Shepard, John, of Assheton, yeoman 1
3680328 1919924 1919924 plaintiff Reynoldys John merchant 602677 602677 Reynoldys, John, of Assheton, merchant 0
3761453 1945594 1945594 defendant Howse John husbandman 602677 602677 Howse, John, of Assheton, husbandman 2
3778355 1950943 1950943 defendant Symons John husbandman 602677 602677 Symons, John, of Assheton, husbandman 1
3781163 1951845 1951845 defendant Burton John husbandman 602677 602677 Burton, John, of Assheton, husbandman 1
3796175 1956671 1956671 defendant Hyckys Henry husbandman 602677 602677 Hyckys, Henry, of Assheton, husbandman 1
3876384 1982347 1982347 defendant Sneston John husbandman 602677 602677 Sneston, John, of Assheton, husbandman 3
3967346 2013207 2013207 defendant Townrowe William yeoman 602677 602677 Townrowe, William, of Assheton, yeoman 0
3971192 2014481 2014481 plaintiff Dykynson Alexander husbandman 602677 602677 Dykynson, Alexander, of Assheton, husbandman 0
3980929 2017939 2017939 defendant Powes William yeoman 602677 602677 Powes, William, of Assheton, yeoman 0
3994174 2022668 2022668 plaintiff Cleverley Ralph yeoman 602677 602677 Cleverley, Ralph, of Assheton, yeoman 0
3994176 2022669 2022669 plaintiff Cleverley Ralph yeoman 602677 602677 Cleverley, Ralph, of Assheton, yeoman 0
4000500 2024948 2024948 defendant Merye Anthony gent 602677 602677 Merye, Anthony, of Assheton, gent 0
4015256 2030149 2030149 defendant Lawe Thomas gent 602677 602677 Lawe, Thomas, of Assheton, gent 1
4051186 2042862 2042862 plaintiff Whyte George clothier 602677 602677 Whyte, George, of Assheton, clothier 0
4051188 2042863 2042863 plaintiff Whyte George clothier 602677 602677 Whyte, George, of Assheton, clothier 0
4167833 2084235 2084235 defendant Austen Robert yeoman 602677 602677 Austen, Robert, of Assheton, Ryngmer, yeoman 2
4482752 2195313 2195313 defendant Hunte John   602677 602677 Hunte, John, of Assheton 2
4482756 2195314 2195314 defendant Hunte John   602677 602677 Hunte, John, of Assheton 2
4487418 2196775 2196775 defendant Draper William   602677 602677 Draper, William, of Assheton 0
4553811 2217117 2217117 plaintiff Glover Robert   602677 602677 Glover, Robert, of Assheton 0
4559742 2219001 2219001 defendant Asshe Thomas   602677 602677 Asshe, Thomas, of Assheton 0
4559743 2219001 2219001 defendant Hykyn Thomas   602677 602677 Hykyn, Thomas, of Assheton 1
4559744 2219001 2219001 defendant Numan John   602677 602677 Numan, John, of Assheton 2
4559746 2219002 2219002 defendant Asshe Thomas   602677 602677 Asshe, Thomas, of Assheton 0
4559747 2219002 2219002 defendant Hykyn Thomas   602677 602677 Hykyn, Thomas, of Assheton 1
4559748 2219002 2219002 defendant Numan John   602677 602677 Numan, John, of Assheton 2
4581601 2225693 2225693 defendant atte Water Thomas   602677 602677 atte Water, Thomas, of Assheton 0
4617590 2236510 2236510 plaintiff Gredlyngton William   602677 602677 Gredlyngton, William, of Assheton 0
4617591 2236510 2236510 defendant Kyng John   602677 602677 Kyng, John, of Assheton 0
4640707 2243389 2243389 defendant Hendeman John   602677 602677 Hendeman, John, of Assheton 0
4645964 2244891 2244891 defendant Crowelonde John   602677 602677 Crowelonde, John, of Assheton 6
4657927 2248364 2248364 defendant Ireland Robert gent 602677 602677 Ireland, Robert, of Assheton, gent 0
4661418 2249397 2249397 defendant Ireland Robert yeoman 602677 602677 Ireland, Robert, of Assheton, yeoman 0
4661419 2249398 2249398 defendant Ireland Robert yeoman 602677 602677 Ireland, Robert, of Assheton, yeoman 0
4668577 2255881 2255881 defendant Hoper John husbandman 602677 602677 Hoper, John, of Assheton, husbandman 0
4672750 2257120 2257120 defendant Ireland Robert gent 602677 602677 Ireland, Robert, of Assheton, gent 0
4687411 2261660 2261660 defendant Rodenay Joan   602677 602677 Rodenay, Joan, of Assheton, widow & formerly wife of Walter Rodenay Assheton, knight 0
4691356 2262820 2262820 defendant Mangue John gent 602677 602677 Mangue, John, of Assheton, gent 0
4717106 2270679 2270679 defendant Maugue John gent 602677 602677 Maugue, John, of Assheton, gent 0
4722368 2272316 2272316 defendant Irelond Robert yeoman 602677 602677 Irelond, Robert, of Assheton, yeoman 0
4759950 2283449 2283449 defendant Irelond Robert yeoman 602677 602677 Irelond, Robert, of Assheton, yeoman 0
4769480 2286433 2286433 defendant Weyse John esq 602677 602677 (Weyse, John, of Assheton, esq 1
4776827 2288740 2288740 defendant Irelond Robert yeoman 602677 602677 Irelond, Robert, of Assheton, yeoman 0
4793982 2294247 2294247 defendant Ireland Robert yeoman 602677 602677 Ireland, Robert, of Assheton, yeoman 0
4802669 2297022 2297022 defendant Asshewell Margaret   602677 602677 Asshewell, Margaret, of Assheton, servant 1
4830548 2305576 2305576 defendant Epham Robert husbandman 602677 602677 Epham, Robert, of Assheton, husbandman 0
4877316 2319861 2319861 defendant Hykkes Simon husbandman 602677 602677 Hykkes, Simon, of Assheton, husbandman 0
4925412 2334381 2334381 defendant Irelond Robert yeoman 602677 602677 Irelond, Robert, of Assheton, yeoman 0
4929013 2335500 2335500 defendant Catte John yeoman 602677 602677 Catte, John, of Assheton, yeoman 3
4929424 2335620 2335620 defendant Pole Thomas yeoman 602677 602677 Pole, Thomas, of Assheton, yeoman 0
4931145 2336128 2336128 plaintiff Vale Walter   602677 602677 Vale, Walter, of Assheton 0
4936009 2337663 2337663 defendant Wyxsy John husbandman 602677 602677 Wyxsy, John, of Assheton, husbandman 0
4950921 2342253 2342253 defendant Colyn William miller 602677 602677 Colyn, William, of Assheton, miller 1
4968249 2347459 2347459 defendant Shiphurd John husbandman 602677 602677 Shiphurd, John, of Assheton, husbandman 0
4973769 2349111 2349111 defendant Walsheman Mathew husbandman 602677 602677 Walsheman, Mathew, of Assheton, husbandman 1
5006779 2358882 2358882 plaintiff Simondes Thomas   602677 602677 Simondes, Thomas, of Assheton 1
5009496 2359655 2359655 defendant Skevyngton Nicholas husbandman 602677 602677 Skevyngton, Nicholas, of Assheton, husbandman 0
5020877 2363003 2363003 plaintiff Everard Thomas   602677 602677 Everard, Thomas, of Assheton 0
5065664 2376258 2376258 defendant of Barowe John yeoman 602677 602677 of Barowe, John, of Assheton, yeoman 2
5113675 2390390 2390390 defendant Erlyche Richard yeoman 602677 602677 Erlyche, Richard, of Assheton, yeoman 3
5126785 2394308 2394308 defendant Hampton Richard yeoman 602677 602677 Hampton, Richard, of Assheton, yeoman 10
5136844 2397298 2397298 defendant Laurence Agnes widow 602677 602677 Laurence, Agnes, of Assheton, widow 1
5180003 2409885 2409885 defendant Frankeleyn John husbandman 602677 602677 Frankeleyn, John, of Assheton, husbandman 0
5180004 2409885 2409885 defendant Coll John husbandman 602677 602677 Coll, John, of Assheton, husbandman 1
5195133 2414324 2414324 defendant Laurence _am esq 602677 602677 Laurence, _am, of Assheton, by Lancaster, Lancs, esq 0
5195143 2414326 2414326 defendant Laurence Thomas esq 602677 602677 Laurence, Thomas, of Assheton, by Lancaster, Lancs, esq 0
5202188 2416403 2416403 defendant Frankeleyn John husbandman 602677 602677 Frankeleyn, John, of Assheton, husbandman 0
5202189 2416403 2416403 defendant Coll John husbandman 602677 602677 Coll, John, of Assheton, husbandman 1
5231489 2424795 2424795 defendant Baldewyn John husbandman 602677 602677 Baldewyn, John, of Assheton, husbandman 2
5240107 2427306 2427306 defendant Conycote Thomas husbandman 602677 602677 Conycote, Thomas, of Assheton, husbandman 4
5289978 2442073 2442073 defendant Wheler alias Bultell John husbandman 602677 602677 Wheler alias Bultell, John, of Assheton, husbandman 0
5390176 2472252 2472252 defendant Freman William, senior husbandman 602677 602677 Freman, William, senior, of Assheton, husbandman 3
5399982 2475079 2475079 defendant Grene Stephen husbandman 602677 602677 Grene, Stephen, of Assheton, husbandman 5
5401099 2475377 2475377 defendant Harrys Richard laborer 602677 602677 Harrys, Richard, of Assheton, laborer 2
5402962 2475928 2475928 defendant Freman William, senior husbandman 602677 602677 Freman, William, senior, of Assheton, husbandman 3
5412974 2478821 2478821 defendant Grene Stephen yeoman 602677 602677 Grene, Stephen, of Assheton, yeoman 5
5415937 2479699 2479699 defendant Freman William, sen husbandman 602677 602677 Freman, William, sen, of Assheton, husbandman 3
5428027 2483335 2483335 defendant Grene Stephen husbandman 602677 602677 Grene, Stephen, of Assheton, husbandman 4
5470400 2496067 2496067 defendant White William butcher 602677 602677 White, William, of Assheton, butcher 2
5470402 2496067 2496067 defendant Alant Thomas husbandman 602677 602677 Alant, Thomas, of Assheton, husbandman 4
5478081 2498468 2498468 defendant Nerber Nicholas gent 602677 602677 Nerber, Nicholas, of Assheton, gent 1
5504401 2506293 2506293 defendant Colyer John husbandman 602677 602677 Colyer, John, of Assheton, husbandman 1
5504402 2506293 2506293 defendant Gilmore John husbandman 602677 602677 Gilmore, John, of Assheton, husbandman 2
5504403 2506293 2506293 defendant Bartelot Robert husbandman 602677 602677 Bartelot, Robert, of Assheton, husbandman 3
5504404 2506293 2506293 defendant Wheler John husbandman 602677 602677 Wheler, John, of Assheton, husbandman 4
5504405 2506293 2506293 defendant Churche Richard husbandman 602677 602677 Churche, Richard, of Assheton, husbandman 5
5510420 2508101 2508101 defendant Troslowe Thomas weaver 602677 602677 Troslowe, Thomas, of Assheton, weaver 0
5510421 2508101 2508101 defendant Tytte Edward weaver 602677 602677 Tytte, Edward, of Assheton, weaver 1
5510422 2508101 2508101 defendant Davy John weaver 602677 602677 Davy, John, of Assheton, weaver 2
5560092 2522911 2522911 defendant Melton John esq 602677 602677 Melton, John, of Assheton, esq 1
5576988 2527847 2527847 defendant Taylour Robert husbandman 602677 602677 Taylour, Robert, of Assheton, husbandman 1
5589698 2531774 2531774 defendant Baldewyn John husbandman 602677 602677 Baldewyn, John, of Assheton, husbandman 2
5627561 2552592 2552592 defendant Smyth John smith 602677 602677 Smyth, John, of Assheton, smith 4

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