names

99 rows where place_id = 588583

✎ 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
3594988 1866062 1866062 defendant Salys John clerk 588583 588583 Salys, John, of Caston, clerk 0
3606502 1869707 1869707 defendant Curteys John yeoman 588583 588583 Curteys, John, of Caston, yeoman 0
3617775 1873183 1873183 defendant Lalle Thomas husbandman 588583 588583 Lalle, Thomas, of Caston, husbandman 2
3641694 1907859 1907859 defendant Bekerton Robert weaver 588583 588583 Bekerton, Robert, of Caston, weaver 0
3657984 1912749 1912749 defendant Gibbys Geoffrey smith 588583 588583 Gibbys, Geoffrey, of Caston, smith 0
3663468 1914500 1914500 defendant Lumney Robert husbandman 588583 588583 Lumney, Robert, of Caston, husbandman 0
3667688 1915839 1915839 defendant Broun Richard husbandman 588583 588583 Broun, Richard, of Caston, husbandman 3
3803074 1958864 1958864 defendant Sturges John, junior gent 588583 588583 Sturges, John, junior, of Caston, gent 0
3803400 1958965 1958965 defendant Sturgeis John gent 588583 588583 Sturgeis, John, of Caston, gent 0
3834138 1968619 1968619 defendant Sturges John, junior gent 588583 588583 Sturges, John, junior, of Caston, gent 0
3842744 1971263 1971263 defendant Tapseman Edmund butcher 588583 588583 Tapseman, Edmund, of Caston, butcher 1
3866439 1979007 1979007 plaintiff Potter Ambrose gent 588583 588583 Potter, Ambrose, of Caston, gent 0
3913073 1994701 1994701 defendant Abbys Thomas husbandman 588583 588583 Abbys, Thomas, of Caston, husbandman 1
4011785 2028952 2028952 defendant Browne John husbandman 588583 588583 Browne, John, of Caston, husbandman 0
4034376 2036967 2036967 defendant Chamberleyn Thomas husbandman 588583 588583 Chamberleyn, Thomas, of Caston, husbandman 0
4034377 2036967 2036967 defendant Pecke Alexander laborer 588583 588583 Pecke, Alexander, of Caston, laborer 1
4034379 2036967 2036967 defendant Sleye Richard weaver 588583 588583 Sleye, Richard, of Caston, weaver 3
4050217 2042510 2042510 defendant Browne John husbandman 588583 588583 Browne, John, of Caston, husbandman 1
4060397 2046118 2046118 defendant Potter Ambrose shoemaker 588583 588583 Potter, Ambrose, of Caston, shoemaker 0
4061331 2046456 2046456 plaintiff Duffyld Henry   588583 588583 Duffyld, Henry, of Caston, shepherd 0
4061335 2046457 2046457 plaintiff Duffyld Henry   588583 588583 Duffyld, Henry, of Caston, shepherd 0
4071113 2049973 2049973 defendant Chamberleyn Thomas husbandman 588583 588583 Chamberleyn, Thomas, of Caston, husbandman 1
4099829 2060263 2060263 defendant Lawrence William clerk 588583 588583 Lawrence, William, of Caston, clerk 2
4136050 2073234 2073234 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4136051 2073234 2073234 defendant Maywood Robert husbandman 588583 588583 Maywood, Robert, of Caston, husbandman 1
4150620 2078352 2078352 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4155711 2080079 2080079 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4173277 2086114 2086114 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4192012 2092764 2092764 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4196600 2094358 2094358 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, or of Gurston, yeoman 0
4196605 2094359 2094359 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4199357 2095328 2095328 defendant Laurence William clerk 588583 588583 Laurence, William, of Caston, clerk 0
4203400 2096740 2096740 defendant Lawrance William clerk 588583 588583 Lawrance, William, of Caston, clerk 0
4203401 2096740 2096740 defendant Rednall Edward yeoman 588583 588583 Rednall, Edward, of Caston, yeoman 1
4205972 2097634 2097634 defendant Potter Ambrose yeoman 588583 588583 Potter, Ambrose, of Caston, yeoman 0
4221366 2102972 2102972 defendant Lawrance William clerk 588583 588583 Lawrance, William, of Caston, clerk 2
4247177 2112031 2112031 defendant Lawrance William clerk 588583 588583 Lawrance, William, of Caston, clerk 2
4386923 2160291 2160291 defendant Harman Robert yeoman 588583 588583 Harman, Robert, of Caston, yeoman 1
4391569 2161792 2161792 defendant Snell Rose widow 588583 588583 Snell, Rose, of Caston, widow 2
4529977 2209666 2209666 defendant Elys Thomas   588583 588583 Elys, Thomas, of Caston 2
4558320 2218543 2218543 defendant Fullere Robert   588583 588583 Fullere, Robert, of Caston 0
4568142 2221602 2221602 defendant Sad John   588583 588583 Sad, John, of Caston, parson 0
4582913 2226082 2226082 defendant Palle John   588583 588583 Palle, John, of Caston 3
4589093 2227968 2227968 defendant Cadde John   588583 588583 Cadde, John, of Caston, parson 1
4600563 2231398 2231398 defendant Fuller Robert   588583 588583 Fuller, Robert, of Caston 0
4619438 2237070 2237070 defendant Fullere Robert   588583 588583 Fullere, Robert, of Caston 1
4666665 2255293 2255293 defendant atte Medewe Thomas yeoman 588583 588583 atte Medewe, Thomas, of Caston, yeoman 4
4732317 2275285 2275285 defendant Cosyn James butcher 588583 588583 Cosyn, James, of Caston, butcher 0
4745823 2279284 2279284 defendant Boure John butcher 588583 588583 Boure, John, of Caston, butcher 4
4746121 2279362 2279362 defendant Cofyn James butcher 588583 588583 Cofyn, James, of Caston, butcher 0
4761132 2283833 2283833 defendant Cosyn James butcher 588583 588583 Cosyn, James, of Caston, butcher 1
4764584 2284910 2284910 defendant Hokham Peter gent 588583 588583 Hokham, Peter, of Caston, gent 0
4786285 2291754 2291754 defendant Adam John yeoiman 588583 588583 Adam, John, of Caston, yeoiman 0
4939465 2338726 2338726 plaintiff Cosyn James husbandman 588583 588583 Cosyn, James, of Caston, husbandman 0
4939466 2338726 2338726 defendant Gernage or Gervage Thomas husbandman 588583 588583 Gernage or Gervage, Thomas, of Caston, husbandman 0
5014695 2361167 2361167 defendant Cosyn James butcher 588583 588583 Cosyn, James, of Caston, butcher 0
5014696 2361167 2361167 defendant Cosyn Thomas butcher 588583 588583 Cosyn, Thomas, of Caston, butcher 1
5023637 2363822 2363822 defendant Cosyn James butcher 588583 588583 Cosyn, James, of Caston, butcher 7
5037246 2367762 2367762 defendant Cappe John yeoman 588583 588583 Cappe, John, of Caston, yeoman 3
5050429 2371753 2371753 defendant Cosyn James butcher 588583 588583 Cosyn, James, of Caston, butcher 0
5111061 2389624 2389624 defendant Cosyn Thomas butcher 588583 588583 Cosyn, Thomas, of Caston, butcher 0
5116778 2391339 2391339 defendant Cappe John husbandman 588583 588583 Cappe, John, of Caston, husbandman 0
5279935 2439206 2439206 defendant Umbray Thomas husbandman 588583 588583 Umbray, Thomas, of Caston, husbandman 1
5279936 2439206 2439206 defendant Frende Roger   588583 588583 Frende, Roger, of Caston, yeoman, admnistrators of 2
5279940 2439207 2439207 defendant Umbray Thomas husbandman 588583 588583 Umbray, Thomas, of Caston, husbandman 1
5279942 2439207 2439207 defendant Frende Roger   588583 588583 Frende, Roger, of Caston, yeoman, administrators of 3
5279946 2439208 2439208 defendant Cosyn John butcher 588583 588583 (Cosyn, John, of Caston, butcher 1
5279947 2439208 2439208 defendant Umbray Thomas husbandman 588583 588583 Umbray, Thomas, of Caston, husbandman 2
5280039 2439235 2439235 defendant Rychardys Thomas pedder 588583 588583 Rychardys, Thomas, of Caston, pedder 0
5286674 2441113 2441113 defendant Rychardys Thomas yeoman 588583 588583 Rychardys, Thomas, of Caston, yeoman 0
5288487 2441649 2441649 defendant Richardys Thomas yeoman 588583 588583 Richardys, Thomas, of Caston, yeoman 1
5299593 2444852 2444852 defendant Richardys Thomas   588583 588583 together with Richardys, Thomas, of Caston, pedlar 1
5299595 2444853 2444853 defendant Rychardys Thomas   588583 588583 Rychardys, Thomas, of Caston, pedlar 0
5308944 2447720 2447720 defendant Rychardes Thomas yeoman 588583 588583 Rychardes, Thomas, of Caston, yeoman 0
5308950 2447722 2447722 defendant Tong Thomas yeoman 588583 588583 Tong, Thomas, of Caston, yeoman 0
5313228 2448990 2448990 defendant Rychardys Thomas pedder 588583 588583 Rychardys, Thomas, of Caston, pedder 0
5318988 2450771 2450771 defendant Rychard Thomas yeoman 588583 588583 Rychard, Thomas, of Caston, yeoman 0
5318989 2450771 2450771 defendant Novy Richard tanner 588583 588583 Novy, Richard, of Caston, tanner 1
5318990 2450771 2450771 defendant Hawes John cordwainer 588583 588583 Hawes, John, of Caston, cordwainer 2
5318991 2450771 2450771 defendant Brown William husbandman 588583 588583 Brown, William, of Caston, husbandman 3
5325624 2452740 2452740 defendant Rycherys Thomas sherman 588583 588583 Rycherys, Thomas, of Caston, sherman 1
5326032 2452879 2452879 defendant Rychardys Thomas yeoman 588583 588583 Rychardys, Thomas, of Caston, yeoman 0
5333355 2455049 2455049 defendant Rychardys Thomas yeoman 588583 588583 Rychardys, Thomas, of Caston, yeoman 0
5348258 2459597 2459597 defendant Richirs Thomas husbandman 588583 588583 Richirs, Thomas, of Caston, husbandman 9
5348264 2459598 2459598 defendant Rychardes Thomas pedder 588583 588583 Rychardes, Thomas, of Caston, pedder 4
5365632 2464920 2464920 defendant Rychardys Thomas pedder 588583 588583 Rychardys, Thomas, of Caston, pedder 3
5410002 2477960 2477960 defendant Richardys Thomas husbandman 588583 588583 Richardys, Thomas, of Caston, husbandman 4
5478720 2498658 2498658 defendant Richardis Thomas husbandman 588583 588583 Richardis, Thomas, of Caston, husbandman 6
5498816 2504586 2504586 defendant Morley Thomas yeoman 588583 588583 Morley, Thomas, of Caston, yeoman 0
5508646 2507569 2507569 defendant Rychardys Thomas pedder 588583 588583 Rychardys, Thomas, of Caston, pedder 4
5513470 2509059 2509059 defendant Morley Thomas husbandman 588583 588583 Morley, Thomas, of Caston, husbandman 1
5544595 2518419 2518419 defendant Richard Richard (legal representative) 588583 588583 Richard, Richard, of Caston, husbandman, executors of 0
5560751 2523110 2523110 defendant Smyth John husbandman 588583 588583 Smyth, John, of Caston, husbandman 0
5561310 2523288 2523288 defendant Bekyrton Robert   588583 588583 Bekyrton, Robert, of Caston, woolen weaver 0
5570841 2526029 2526029 defendant Fechett Gilbert husbandman 588583 588583 Fechett, Gilbert, of Caston, husbandman 1
5571129 2526118 2526118 defendant Howes William husbandman 588583 588583 Howes, William, of Caston, husbandman 1
5596170 2533718 2533718 defendant Bekerton Robert weaver 588583 588583 Bekerton, Robert, of Caston, weaver 1
5626556 2552277 2552277 defendant Fuller Robert husbandman 588583 588583 Fuller, Robert, of Caston, husbandman 1
5628040 2552741 2552741 defendant Fullere Robert husbandman 588583 588583 Fullere, Robert, of Caston, husbandman 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);