names

76 rows where place_id = 593733

✎ 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
3613123 1871757 1871757 defendant Wodman William husbandman 593733 593733 Wodman, William, of Dalyngton, husbandman 0
3615232 1872412 1872412 defendant Rabet Richard husbandman 593733 593733 Rabet, Richard, of Dalyngton, husbandman 0
3617804 1873192 1873192 defendant Wodelond Richard clerk 593733 593733 Wodelond, Richard, of Dalyngton, clerk 0
3617806 1873193 1873193 defendant Wodelond Richard clerk 593733 593733 Wodelond, Richard, of Dalyngton, clerk 0
3618391 1873385 1873385 defendant Priour William husbandman 593733 593733 Priour, William, of Dalyngton, husbandman 0
3644829 1908789 1908789 defendant Ryche John tanner 593733 593733 Ryche, John, of Dalyngton, tanner 3
3720130 1932572 1932572 defendant Glasyer Thomas laborer 593733 593733 Glasyer, Thomas, of Dalyngton, laborer 1
3720131 1932572 1932572 defendant Downe John laborer 593733 593733 Downe, John, of Dalyngton, laborer 2
3722599 1933328 1933328 defendant Praty Thomas husbandman 593733 593733 Praty, Thomas, of Dalyngton, husbandman 1
3722600 1933328 1933328 defendant Mendall Thomas husbandman 593733 593733 Mendall, Thomas, of Dalyngton, husbandman 2
3722601 1933328 1933328 defendant Bray John husbandman 593733 593733 Bray, John, of Dalyngton, husbandman 3
3802956 1958822 1958822 defendant Glasyer Thomas husbandman 593733 593733 Glasyer, Thomas, of Dalyngton, husbandman 0
3831250 1967659 1967659 defendant Hogge Andrew husbandman 593733 593733 Hogge, Andrew, of Dalyngton, husbandman 2
3920219 1997101 1997101 defendant Lees Christopher shoemaker 593733 593733 Lees, Christopher, of Dalyngton, shoemaker 0
3924046 1998352 1998352 defendant Shether Richard husbandman 593733 593733 Shether, Richard, of Dalyngton, husbandman 1
3985369 2019526 2019526 defendant Longley Anthony husbandman 593733 593733 Longley, Anthony, of Dalyngton, husbandman 0
4467346 2190466 2190466 plaintiff atte Tye Adam   593733 593733 atte Tye, Adam, of Dalyngton, vicar 0
4473692 2192415 2192415 plaintiff Dalyngton John   593733 593733 Dalyngton, John, of Dalyngton 0
4507235 2202728 2202728 defendant Conset William   593733 593733 Conset, William, of Dalyngton 3
4531476 2210120 2210120 defendant Bokholt John   593733 593733 Bokholt, John, of Dalyngton 0
4606966 2233288 2233288 defendant Russell William   593733 593733 Russell, William, of Dalyngton 0
4677199 2258486 2258486 defendant Colyngham John husbandman 593733 593733 Colyngham, John, of Dalyngton, husbandman 1
4697422 2264682 2264682 defendant Wodesell Thomas tailor 593733 593733 Wodesell, Thomas, of Dalyngton, tailor 0
4697423 2264682 2264682 defendant Stevene William tailor 593733 593733 Stevene, William, of Dalyngton, tailor 1
4697424 2264682 2264682 defendant Ferne John tanner 593733 593733 Ferne, John, of Dalyngton, tanner 2
4710449 2268626 2268626 defendant Wodeselle Thomas tailor 593733 593733 Wodeselle, Thomas, of Dalyngton, tailor 0
4710450 2268626 2268626 defendant Stevene William tailor 593733 593733 Stevene, William, of Dalyngton, tailor 1
4710451 2268626 2268626 defendant Verne John tanner 593733 593733 Verne, John, of Dalyngton, tanner 2
4714080 2269732 2269732 defendant Ferne John tanner 593733 593733 Ferne, John, of Dalyngton, tanner 0
4730452 2274720 2274720 defendant atte Mede Sarah   593733 593733 atte Mede, Sarah, of Dalyngton, widow, formerly wife of William 1
4738694 2277191 2277191 defendant Staneley or Staveley John tailor 593733 593733 Staneley or Staveley, John, of Dalyngton, tailor 2
4738901 2277257 2277257 defendant Stephene William tailor 593733 593733 Stephene, William, of Dalyngton, tailor 0
4740020 2277595 2277595 defendant Croucher John, senior fuller 593733 593733 Croucher, John, senior, of Dalyngton, fuller 0
4740022 2277596 2277596 defendant Hastyng Robert laborer 593733 593733 Hastyng, Robert, of Dalyngton, laborer 0
4740023 2277596 2277596 defendant Russell William husbandman 593733 593733 Russell, William, of Dalyngton, husbandman 1
4802238 2296889 2296889 defendant Russell William husbandman 593733 593733 Russell, William, of Dalyngton, husbandman 0
4822989 2303271 2303271 defendant Hamond William yeoman 593733 593733 Hamond, William, of Dalyngton, yeoman 4
4828175 2304855 2304855 defendant Russell William husbandman 593733 593733 Russell, William, of Dalyngton, husbandman 0
4837834 2307765 2307765 defendant Russell Henry husbandman 593733 593733 Russell, Henry, of Dalyngton, husbandman 0
4852168 2312108 2312108 defendant Travers Thomas husbandman 593733 593733 Travers, Thomas, of Dalyngton, husbandman 0
4853869 2312619 2312619 defendant Travers Thomas husbandman 593733 593733 Travers, Thomas, of Dalyngton, husbandman 4
4927847 2335144 2335144 defendant Croucher Simon husbandman 593733 593733 Croucher, Simon, of Dalyngton, husbandman 1
5061368 2374984 2374984 defendant Russell Henry husbandman 593733 593733 Russell, Henry, of Dalyngton, husbandman 0
5071772 2378051 2378051 plaintiff Stephyn William (legal representative) 593733 593733 Stephyn, William, of Dalyngton, executors of 0
5078422 2380044 2380044 defendant Hunte Thomas   593733 593733 Hunte, Thomas, of Dalyngton, freemason 0
5088360 2382970 2382970 defendant Birchet Peter dyer 593733 593733 Birchet, Peter, of Dalyngton, dyer 0
5101894 2386974 2386974 defendant Croucher Simon husbandman 593733 593733 Croucher, Simon, of Dalyngton, husbandman 0
5111914 2389873 2389873 defendant Lambe John yeoman 593733 593733 Lambe, John, of Dalyngton, yeoman 0
5114232 2390553 2390553 defendant -ukkyng Thomas   593733 593733 -ukkyng, Thomas, of Dalyngton, tile maker 1
5114233 2390553 2390553 defendant Croucher Simon husbandman 593733 593733 Croucher, Simon, of Dalyngton, husbandman 2
5120603 2392453 2392453 plaintiff Stephyn William (legal representative) 593733 593733 Stephyn, William, of Dalyngton, executors of 0
5120607 2392454 2392454 plaintiff Stephyn William (legal representative) 593733 593733 Stephyn, William, of Dalyngton, executors of 0
5212222 2419314 2419314 defendant Croucher Simon laborer 593733 593733 Croucher, Simon, of Dalyngton, laborer 0
5215652 2420301 2420301 defendant Farlegh Henry clerk 593733 593733 Farlegh, Henry, of Dalyngton, clerk 0
5215653 2420301 2420301 defendant Russell John laborer 593733 593733 Russell, John, of Dalyngton, laborer 1
5222731 2422365 2422365 defendant Graunger John yeoman 593733 593733 Graunger, John, of Dalyngton, yeoman 2
5238857 2426954 2426954 defendant Randolf John husbandman 593733 593733 Randolf, John, of Dalyngton, husbandman 0
5238858 2426954 2426954 defendant Elys Hnry husbandman 593733 593733 Elys, Hnry, of Dalyngton, husbandman 1
5245310 2428788 2428788 defendant Rebet Richard   593733 593733 Rebet, Richard, of Dalyngton 0
5248029 2429560 2429560 plaintiff Stephyn William (legal representative) 593733 593733 Stephyn, William, of Dalyngton, executors of 0
5277572 2438516 2438516 defendant Broke James yeoman 593733 593733 Broke, James, of Dalyngton, yeoman 0
5297782 2444357 2444357 defendant Broke James yeoman 593733 593733 Broke, James, of Dalyngton, yeoman 0
5297784 2444358 2444358 defendant Broke James yeoman 593733 593733 Broke, James, of Dalyngton, yeoman 0
5297790 2444360 2444360 defendant Russell Thomas   593733 593733 Russell, Thomas, of Dalyngton 2
5312143 2448665 2448665 defendant Broke James yeoman 593733 593733 Broke, James, of Dalyngton, yeoman 0
5312148 2448667 2448667 defendant Russell Thomas, senior husbandman 593733 593733 Russell, Thomas, senior, of Dalyngton, husbandman 1
5312149 2448667 2448667 defendant Wodeman Simon laborer 593733 593733 Wodeman, Simon, of Dalyngton, laborer 2
5312158 2448670 2448670 defendant Broke James yeoman 593733 593733 Broke, James, of Dalyngton, yeoman 0
5317425 2450295 2450295 defendant Penkherst John yeoman 593733 593733 Penkherst, John, of Dalyngton, yeoman 0
5383653 2470407 2470407 defendant Spycer Richard butcher 593733 593733 Spycer, Richard, of Dalyngton, butcher 3
5383655 2470408 2470408 defendant Wade John husbandman 593733 593733 Wade, John, of Dalyngton, husbandman 0
5485561 2500591 2500591 defendant Wade John husbandman 593733 593733 Wade, John, of Dalyngton, husbandman 0
5514076 2509253 2509253 defendant Kenet William husbandman 593733 593733 Kenet, William, of Dalyngton, husbandman 0
5514077 2509253 2509253 defendant Priour Richard husbandman 593733 593733 Priour, Richard, of Dalyngton, husbandman 1
5530407 2514025 2514025 defendant Wodman William husbandman 593733 593733 Wodman, William, of Dalyngton, husbandman 0
5530408 2514026 2514026 defendant Wodman William husbandman 593733 593733 Wodman, William, of Dalyngton, 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);