names

82 rows where place_id = 608917

✎ 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
3676124 1918572 1918572 defendant Keteryng Robert tanner 608917 608917 Keteryng, Robert, of Yerdeley, tanner 2
3705320 1927953 1927953 defendant Roche John husbandman 608917 608917 Roche, John, of Yerdeley, husbandman 3
3706320 1928264 1928264 defendant Bryan Thomas clerk 608917 608917 Bryan, Thomas, of Yerdeley, clerk 0
3714134 1930722 1930722 defendant Gaylard George yeoman 608917 608917 Gaylard, George, of Yerdeley, yeoman 0
3714135 1930722 1930722 defendant Halfhyde John summoner or tanner 608917 608917 Halfhyde, John, of Yerdeley, summoner or tanner 1
3718807 1932163 1932163 defendant Warrant John maltman 608917 608917 Warrant, John, of Yerdeley, maltman 0
3723924 1933762 1933762 defendant Austen Joan widow 608917 608917 Austen, Joan, of Yerdeley, widow 3
3744123 1940062 1940062 defendant Gayler George husbandman 608917 608917 Gayler, George, of Yerdeley, husbandman 0
3781067 1951813 1951813 defendant Corffe John husbandman 608917 608917 Corffe, John, of Yerdeley, husbandman 0
3816910 1963196 1963196 defendant Hyggons Simon weaver 608917 608917 Hyggons, Simon, of Yerdeley, weaver 0
3843467 1971494 1971494 defendant Gayler George husbandman 608917 608917 Gayler, George, of Yerdeley, husbandman 0
3858584 1976356 1976356 defendant Pratty John gent 608917 608917 Pratty, John, of Yerdeley, gent 0
3877024 1982557 1982557 plaintiff Hemerston John tanner 608917 608917 Hemerston, John, of Yerdeley, tanner 0
3898354 1989660 1989660 defendant Clynton Leonard carpenter 608917 608917 Clynton, Leonard, of Yerdeley, carpenter 0
3915018 1995377 1995377 defendant Elson John yeoman 608917 608917 Elson, John, of Yerdeley, yeoman 0
4523551 2207690 2207690 plaintiff Hawe John   608917 608917 Hawe, John, of Yerdeley 0
4523552 2207690 2207690 plaintiff Makehayt Roger   608917 608917 Makehayt, Roger, of Yerdeley 1
4572504 2222935 2222935 defendant Forde John butcher 608917 608917 Forde, John, of Yerdeley, butcher 0
4574682 2223609 2223609 plaintiff Bette William   608917 608917 Bette, William, of Yerdeley 0
4592848 2229095 2229095 plaintiff Otheyn John   608917 608917 Otheyn, John, of Yerdeley 0
4667097 2255443 2255443 defendant Sherley John yeoman 608917 608917 Sherley, John, of Yerdeley, yeoman 0
4712475 2269218 2269218 defendant Wodehous William husbandman 608917 608917 Wodehous, William, of Yerdeley, husbandman 0
4720597 2271775 2271775 defendant Crouche Thomas husbandman 608917 608917 Crouche, Thomas, of Yerdeley, husbandman 0
4756851 2282508 2282508 defendant Stokes Richard yeoman 608917 608917 Stokes, Richard, of Yerdeley, yeoman 0
4760819 2283720 2283720 plaintiff Daunser Robert   608917 608917 Daunser, Robert, of Yerdeley, vicar 0
4801347 2296610 2296610 defendant Bragge Richard carpenter 608917 608917 Bragge, Richard, of Yerdeley, carpenter 2
4812058 2299884 2299884 defendant Smalbrook William yeoman 608917 608917 Smalbrook, William, of Yerdeley, yeoman 0
4855737 2313169 2313169 plaintiff atte Wode William   608917 608917 atte Wode, William, of Yerdeley 0
4855739 2313170 2313170 plaintiff atte Wode William   608917 608917 atte Wode, William, of Yerdeley 0
4870730 2317823 2317823 defendant Lyffyng Thomas husbandman 608917 608917 Lyffyng, Thomas, of Yerdeley, husbandman 1
4895803 2325364 2325364 defendant Wykemylle Henry gent 608917 608917 Wykemylle, Henry, of Yerdeley, gent 0
4927525 2335045 2335045 defendant Austyn John   608917 608917 Austyn, John, of Yerdeley 0
4954766 2343380 2343380 defendant Halsede or Halfede William husbandman 608917 608917 Halsede or Halfede, William, of Yerdeley, husbandman 0
4955168 2343504 2343504 defendant Stretton William tailor 608917 608917 Stretton, William, of Yerdeley, tailor 3
4967920 2347348 2347348 defendant Merston William husbandman 608917 608917 Merston, William, of Yerdeley, husbandman 0
4967921 2347348 2347348 defendant Merston Agnes widow 608917 608917 Merston, Agnes, of Yerdeley, widow 1
4967923 2347349 2347349 defendant Merston William husbandman 608917 608917 Merston, William, of Yerdeley, husbandman 0
4967924 2347349 2347349 defendant Merston Agnes widow 608917 608917 Merston, Agnes, of Yerdeley, widow 1
4968560 2347562 2347562 defendant Bogge William laborer 608917 608917 Bogge, William, of Yerdeley, laborer 4
4979189 2350734 2350734 defendant Blakesley Roger husbandman 608917 608917 Blakesley, Roger, of Yerdeley, husbandman 0
4983729 2352060 2352060 defendant Lyffyng Thomas husbandman 608917 608917 Lyffyng, Thomas, of Yerdeley, husbandman 0
4983730 2352060 2352060 defendant Crouche Thomas husbandman 608917 608917 Crouche, Thomas, of Yerdeley, husbandman 1
5092156 2384082 2384082 defendant Dolfy- Richard husbandman 608917 608917 Dolfy-, Richard, of Yerdeley, husbandman 0
5108077 2388802 2388802 defendant Swyft Richard, senior husbandman 608917 608917 Swyft, Richard, senior, of Yerdeley, husbandman 0
5130529 2395411 2395411 defendant Hamon Richard husbandman 608917 608917 Hamon, Richard, of Yerdeley, husbandman 0
5138614 2397789 2397789 defendant Upton John chaplain 608917 608917 Upton, John, of Yerdeley, chaplain 0
5159374 2403857 2403857 defendant Upton John chaplain 608917 608917 Upton, John, of Yerdeley, chaplain 0
5174532 2408252 2408252 defendant Upton Richard chaplain 608917 608917 Upton, Richard, of Yerdeley, chaplain 0
5174534 2408253 2408253 defendant Upton Richard chaplain 608917 608917 Upton, Richard, of Yerdeley, chaplain 0
5177702 2409175 2409175 defendant Upton Richard chaplain 608917 608917 Upton, Richard, of Yerdeley, chaplain 0
5201463 2416187 2416187 plaintiff Austyn John, sen   608917 608917 Austyn, John, sen, of Yerdeley, administrators of 0
5201465 2416187 2416187 plaintiff Alphyde John   608917 608917 Alphyde, John, of Yerdeley 2
5212854 2419504 2419504 defendant Pope John singleman 608917 608917 Pope, John, of Yerdeley, yeoman, singleman 0
5212855 2419504 2419504 defendant Audeley Mathew sawyer 608917 608917 Audeley, Mathew, of Yerdeley, sawyer 1
5242127 2427899 2427899 defendant Gayller Thomas husbandman 608917 608917 Gayller, Thomas, of Yerdeley, husbandman 1
5249436 2429947 2429947 defendant Gayler alias Haylard Thomas husbandman 608917 608917 Gayler alias Haylard, Thomas, of Yerdeley, husbandman 0
5271866 2436861 2436861 defendant Bradshawe Thomas yeoman 608917 608917 Bradshawe, Thomas, of Yerdeley, yeoman 0
5312017 2448623 2448623 defendant Bond Robert yeoman 608917 608917 Bond, Robert, of Yerdeley, yeoman 2
5330432 2454180 2454180 defendant Yerdley John gent 608917 608917 Yerdley, John, of Yerdeley, gent 3
5334544 2455402 2455402 defendant Russell John smith 608917 608917 Russell, John, of Yerdeley, smith 1
5337962 2456439 2456439 defendant Haukesford Ralph baker 608917 608917 Haukesford, Ralph, of Yerdeley, baker 1
5351407 2460540 2460540 defendant Neell John yeoman 608917 608917 Neell, John, of Yerdeley, yeoman 0
5355708 2461863 2461863 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 3
5379791 2469262 2469262 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 0
5397423 2474348 2474348 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 0
5408467 2477503 2477503 defendant Bryan Thomas   608917 608917 Bryan, Thomas, of Yerdeley, wheelwright 0
5410630 2478124 2478124 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 0
5410634 2478126 2478126 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 0
5419930 2480878 2480878 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 0
5433828 2485088 2485088 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 1
5433834 2485089 2485089 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 1
5438480 2486444 2486444 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 0
5449491 2489739 2489739 defendant Andrewe Thomas butcher 608917 608917 Andrewe, Thomas, of Yerdeley, butcher 1
5543057 2517947 2517947 defendant Bratoft William butcher 608917 608917 Bratoft, William, of Yerdeley, butcher 0
5544964 2518532 2518532 defendant Bocher William butcher 608917 608917 Bocher, William, of Yerdeley, butcher 0
5563706 2523993 2523993 defendant Halfhyde John husbandman 608917 608917 Halfhyde, John, of Yerdeley, husbandman 0
5567206 2524986 2524986 defendant Braytoft William yeoman 608917 608917 Braytoft, William, of Yerdeley, yeoman 0
5578590 2528373 2528373 defendant Powell Thomas tailor 608917 608917 Powell, Thomas, of Yerdeley, tailor 0
5590920 2532136 2532136 defendant Mathewe Thomas yeoman 608917 608917 Mathewe, Thomas, of Yerdeley, yeoman 2
5590924 2532137 2532137 defendant Mathewe Thomas yeoman 608917 608917 Mathewe, Thomas, of Yerdeley, yeoman 2
5613869 2548115 2548115 defendant Fulford Agnes de   608917 608917 Fulford, Agnes de, of Yerdeley, formerly wife of Walter 0
5627264 2552496 2552496 defendant Holt John   608917 608917 Holt, John, of Yerdeley 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);