names

99 rows where place_id = 590277

✎ 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
3600460 1867790 1867790 defendant Bulman William gent 590277 590277 Bulman, William, of Hertfeld, gent 0
3612208 1871459 1871459 defendant Saxpese John husbandman 590277 590277 Saxpese, John, of Hertfeld, husbandman 5
3632647 1905027 1905027 defendant Tanner John collier 590277 590277 Tanner, John, of Hertfeld, collier 7
3639909 1907296 1907296 defendant Nasshe John husbandman 590277 590277 Nasshe, John, of Hertfeld, husbandman 0
3639963 1907312 1907312 defendant Bowier John   590277 590277 Bowier, John, of Hertfeld 0
3645858 1909109 1909109 defendant Wykynden Richard yeoman 590277 590277 Wykynden, Richard, of Hertfeld, yeoman 0
3645859 1909109 1909109 defendant Symerd Lambert   590277 590277 Symerd, Lambert, of Hertfeld, iron maker 1
3645860 1909109 1909109 defendant Watson Thomas laborer 590277 590277 Watson, Thomas, of Hertfeld, laborer 2
3729086 1935347 1935347 defendant Rowe William carpenter 590277 590277 Rowe, William, of Hertfeld, carpenter 1
3740708 1938955 1938955 defendant Robyn Reginald finer 590277 590277 Robyn, Reginald, of Hertfeld, finer 1
3745150 1940389 1940389 defendant Moncombyr Rawlyn miner 590277 590277 Moncombyr, Rawlyn, of Hertfeld, miner 0
3745154 1940390 1940390 plaintiff Bowyer John yeoman 590277 590277 Bowyer, John, of Hertfeld, yeoman 0
3748594 1941491 1941491 defendant Courthop John yeoman 590277 590277 Courthop, John, of Hertfeld, yeoman 0
3755669 1943729 1943729 defendant Skoryer Thomas husbandman 590277 590277 Skoryer, Thomas, of Hertfeld, husbandman 2
3757855 1944436 1944436 plaintiff Bowyer John yeoman 590277 590277 Bowyer, John, of Hertfeld, yeoman 0
3762378 1945876 1945876 defendant Saxpeys Robert yeoman 590277 590277 Saxpeys, Robert, of Hertfeld, yeoman 0
3774092 1949610 1949610 plaintiff Alffray William yeoman 590277 590277 Alffray, William, of Hertfeld, yeoman 0
3778389 1950957 1950957 defendant Saxpeys Robert yeoman 590277 590277 Saxpeys, Robert, of Hertfeld, yeoman 0
3778411 1950963 1950963 defendant Jepper Gerard collier 590277 590277 Jepper, Gerard, of Hertfeld, collier 3
3783498 1952590 1952590 defendant Hednay Thomas gent 590277 590277 Hednay, Thomas, of Hertfeld, gent 0
3783506 1952592 1952592 defendant Bowyer John yeoman 590277 590277 Bowyer, John, of Hertfeld, yeoman 0
3795506 1956475 1956475 defendant Messauns William smith 590277 590277 Messauns, William, of Hertfeld, smith 1
3795507 1956475 1956475 defendant Tyler Lewis finer 590277 590277 Tyler, Lewis, of Hertfeld, finer 2
3795508 1956475 1956475 defendant Founder James founder 590277 590277 Founder, James, of Hertfeld, founder 3
3795509 1956475 1956475 defendant Morett James smith 590277 590277 Morett, James, of Hertfeld, smith 4
3799946 1957903 1957903 defendant Hedney Thomas gent 590277 590277 Hedney, Thomas, of Hertfeld, gent 0
3810150 1961064 1961064 defendant Jurdeyn Reginald smith 590277 590277 Jurdeyn, Reginald, of Hertfeld, smith 0
3825843 1965932 1965932 plaintiff Alferey William yeoman 590277 590277 Alferey, William, of Hertfeld, yeoman 0
4443853 2183049 2183049 defendant Joop John   590277 590277 Joop, John, of Hertfeld 2
4542718 2213610 2213610 defendant Swan Roger   590277 590277 Swan, Roger, of Hertfeld 0
4566110 2220960 2220960 defendant Joop Thomas   590277 590277 Joop, Thomas, of Hertfeld 0
4597721 2230538 2230538 plaintiff Skynner John   590277 590277 Skynner, John, of Hertfeld 0
4622306 2237956 2237956 defendant Basset William   590277 590277 Basset, William, of Hertfeld 0
4623568 2238349 2238349 plaintiff Michel William   590277 590277 Michel, William, of Hertfeld 0
4625532 2238948 2238948 defendant Skynner John   590277 590277 Skynner, John, of Hertfeld, son of Thomas 3
4675344 2257898 2257898 defendant Skynner John   590277 590277 Skynner, John, of Hertfeld 3
4707683 2267766 2267766 defendant Skynnere Thomas husbandman 590277 590277 Skynnere, Thomas, of Hertfeld, husbandman 0
4709581 2268355 2268355 defendant Basset William fishmonger 590277 590277 Basset, William, of Hertfeld, fishmonger 0
4721796 2272150 2272150 defendant Apple William husbandman 590277 590277 Apple, William, of Hertfeld, husbandman 0
4725326 2273213 2273213 defendant Stacy William husbandman 590277 590277 Stacy, William, of Hertfeld, husbandman 0
4728577 2274175 2274175 defendant Colyn William laborer 590277 590277 Colyn, William, of Hertfeld, laborer 0
4745684 2279250 2279250 defendant Broun John husbandman 590277 590277 Broun, John, of Hertfeld, husbandman 0
4769094 2286316 2286316 defendant Perot Thomas yeoman 590277 590277 Perot, Thomas, of Hertfeld, yeoman 0
4772835 2287473 2287473 defendant Beyle William husbandman 590277 590277 Beyle, William, of Hertfeld, husbandman 2
4789514 2292790 2292790 defendant Joop Thomas gent 590277 590277 Joop, Thomas, of Hertfeld, gent 0
4790996 2293275 2293275 defendant Joop Thomas, senior gent 590277 590277 Joop, Thomas, senior, of Hertfeld, gent 0
4805314 2297865 2297865 defendant Baker William husbandman 590277 590277 Baker, William, of Hertfeld, husbandman 0
4810739 2299482 2299482 defendant Strode Thomas butcher 590277 590277 Strode, Thomas, of Hertfeld, butcher 0
4823177 2303337 2303337 defendant Avecok John husbandman 590277 590277 Avecok, John, of Hertfeld, husbandman 2
4866189 2316397 2316397 defendant Skynner John husbandman 590277 590277 Skynner, John, of Hertfeld, husbandman 0
4887368 2322885 2322885 defendant atte Lee Walter husbandman 590277 590277 atte Lee, Walter, of Hertfeld, husbandman 0
4887369 2322885 2322885 defendant atte Lee William husbandman 590277 590277 atte Lee, William, of Hertfeld, husbandman 1
4893808 2324759 2324759 defendant Perot Thomas yeoman 590277 590277 Perot, Thomas, of Hertfeld, yeoman 0
4901584 2327096 2327096 defendant Perot Thomas yeoman 590277 590277 Perot, Thomas, of Hertfeld, yeoman 0
4908610 2329246 2329246 defendant Perot Thomas yeoman 590277 590277 Perot, Thomas, of Hertfeld, yeoman 0
4916440 2331642 2331642 defendant Doyle William husbandman 590277 590277 Doyle, William, of Hertfeld, husbandman 0
4916442 2331643 2331643 defendant Boyle William husbandman 590277 590277 Boyle, William, of Hertfeld, husbandman 0
4937457 2338088 2338088 defendant Swayneslond John   590277 590277 Swayneslond, John, of Hertfeld 0
4957132 2344092 2344092 defendant Baker William husbandman 590277 590277 Baker, William, of Hertfeld, husbandman 0
4991519 2354347 2354347 defendant Skynner Richard laborer 590277 590277 Skynner, Richard, of Hertfeld, laborer 0
4991520 2354347 2354347 defendant Strode Thomas butcher 590277 590277 Strode, Thomas, of Hertfeld, butcher 1
5034672 2366998 2366998 defendant Chaloner John butcher 590277 590277 Chaloner, John, of Hertfeld, butcher 1
5035142 2367142 2367142 defendant Golbyn William husbandman 590277 590277 Golbyn, William, of Hertfeld, husbandman 0
5057567 2373831 2373831 defendant Barbour John yeoman 590277 590277 Barbour, John, of Hertfeld, yeoman 0
5058457 2374080 2374080 defendant Memory Thomas butcher 590277 590277 Memory, Thomas, of Hertfeld, butcher 0
5106193 2388248 2388248 defendant Barbour John husbandman 590277 590277 Barbour, John, of Hertfeld, husbandman 0
5106194 2388248 2388248 defendant Skynner Adam husbandman 590277 590277 Skynner, Adam, of Hertfeld, husbandman 1
5106391 2388310 2388310 defendant atte Lee Thomas yeoman 590277 590277 atte Lee, Thomas, of Hertfeld, yeoman 0
5106392 2388310 2388310 defendant Blomer Thomas yeoman 590277 590277 Blomer, Thomas, of Hertfeld, yeoman 1
5131298 2395641 2395641 defendant Perrot Thomas, junior husbandman 590277 590277 Perrot, Thomas, junior, of Hertfeld, husbandman 3
5178895 2409554 2409554 defendant Skynner Richard yeoman 590277 590277 Skynner, Richard, of Hertfeld, yeoman 0
5195424 2414411 2414411 defendant Skynner Richard butcher 590277 590277 Skynner, Richard, of Hertfeld, butcher 0
5196304 2414669 2414669 defendant Eulewyk William gent 590277 590277 Eulewyk, William, of Hertfeld, gent 0
5209283 2418447 2418447 defendant Skynner Richard butcher 590277 590277 Skynner, Richard, of Hertfeld, butcher 0
5214634 2420010 2420010 defendant Skynner Richard yeoman 590277 590277 Skynner, Richard, of Hertfeld, yeoman 0
5232581 2425106 2425106 defendant Wody Thomas husbandman 590277 590277 Wody, Thomas, of Hertfeld, husbandman 0
5232582 2425106 2425106 defendant Bowyer William husbandman 590277 590277 Bowyer, William, of Hertfeld, husbandman 1
5232583 2425106 2425106 defendant Gylbert Roger husbandman 590277 590277 Gylbert, Roger, of Hertfeld, husbandman 2
5232588 2425107 2425107 defendant Perot Thomas laborer 590277 590277 Perot, Thomas, of Hertfeld, laborer 1
5241391 2427677 2427677 defendant Lee Thomas laborer 590277 590277 Lee, Thomas, of Hertfeld, laborer 0
5241392 2427677 2427677 defendant Wylly Oliver laborer 590277 590277 Wylly, Oliver, of Hertfeld, laborer 1
5254131 2431413 2431413 defendant Bowyer Alice widow 590277 590277 Bowyer, Alice, of Hertfeld, widow 1
5254132 2431413 2431413 defendant Bowyer John, junior laborer 590277 590277 Bowyer, John, junior, of Hertfeld, laborer 2
5255938 2431981 2431981 defendant Shepard John laborer 590277 590277 Shepard, John, of Hertfeld, laborer 2
5280012 2439226 2439226 defendant Bowyer John, junior laborer 590277 590277 Bowyer, John, junior, of Hertfeld, laborer 0
5287370 2441330 2441330 defendant Skynner Richard yeoman 590277 590277 Skynner, Richard, of Hertfeld, yeoman 0
5312696 2448834 2448834 defendant Pylcher John yeoman 590277 590277 Pylcher, John, of Hertfeld, yeoman 0
5321806 2451596 2451596 defendant Alcok John husbandman 590277 590277 Alcok, John, of Hertfeld, husbandman 0
5404345 2476317 2476317 defendant Pylcher John, junior   590277 590277 Pylcher, John, junior, of Hertfeld 9
5404363 2476320 2476320 defendant Py--- John, junior yeoman 590277 590277 Py---, John, junior, of Hertfeld, yeoman 10
5507627 2507284 2507284 defendant Couper Richard laborer 590277 590277 Couper, Richard, of Hertfeld, laborer 1
5510822 2508228 2508228 defendant Couper Richard laborer 590277 590277 Couper, Richard, of Hertfeld, laborer 1
5510836 2508233 2508233 defendant Couper Richard laborer 590277 590277 Couper, Richard, of Hertfeld, laborer 1
5554848 2521417 2521417 defendant Grene Lawrence yeoman 590277 590277 Grene, Lawrence, of Hertfeld, yeoman 0
5600371 2535002 2535002 defendant Saxpes John husbandman 590277 590277 Saxpes, John, of Hertfeld, husbandman 0
5602666 2535711 2535711 defendant Symart Pouncelet   590277 590277 Symart, Pouncelet, of Hertfeld, iron founder 21
5602667 2535711 2535711 defendant Robyn Calixtus   590277 590277 Robyn, Calixtus, of Hertfeld, iron finer 22
5604875 2536393 2536393 defendant Anley or Auley Robert chaplain 590277 590277 Anley or Auley, Robert, of Hertfeld, chaplain 2
5617407 2549263 2549263 plaintiff Spysour John   590277 590277 Spysour, John, of Hertfeld, parson 2

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