names

110 rows where place_id = 589774

✎ 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
3598694 1867216 1867216 defendant Rychardson Thomas yeoman 589774 589774 Rychardson, Thomas, of Swynflete, yeoman 0
3598696 1867217 1867217 defendant Rychardson Thomas yeoman 589774 589774 Rychardson, Thomas, of Swynflete, yeoman 0
3601858 1868235 1868235 defendant Alkbarowe Robert yeoman 589774 589774 Alkbarowe, Robert, of Swynflete, yeoman 1
3739630 1938610 1938610 defendant Pynder John yeoman 589774 589774 Pynder, John, of Swynflete, yeoman 0
4024947 2033585 2033585 defendant Hyde John yeoman 589774 589774 Hyde, John, of Swynflete, yeoman 1
4036566 2037762 2037762 defendant Lounde or Lunde Robert gent 589774 589774 Lounde or Lunde, Robert, of Swynflete, gent 0
4070880 2049884 2049884 defendant Hyde John gent 589774 589774 Hyde, John, of Swynflete, gent 0
4075698 2051613 2051613 defendant Richardson Thomas yeoman 589774 589774 Richardson, Thomas, of Swynflete, yeoman 0
4080730 2053419 2053419 plaintiff Wayte Francis gent 589774 589774 Wayte, Francis, of Swynflete, gent 0
4080732 2053420 2053420 plaintiff Wayte Francis gent 589774 589774 Wayte, Francis, of Swynflete, gent 0
4080735 2053420 2053420 defendant Richardson Thomas yeoman 589774 589774 Richardson, Thomas, of Swynflete, yeoman 2
4080736 2053420 2053420 defendant Beamesley John yeoman 589774 589774 Beamesley, John, of Swynflete, yeoman 3
4090596 2056920 2056920 defendant Wayte Richard yeoman 589774 589774 Wayte, Richard, of Swynflete, yeoman 0
4091567 2057275 2057275 defendant Wayte Francis gent 589774 589774 Wayte, Francis, of Swynflete, gent 2
4107143 2062848 2062848 plaintiff Pennythorne Robert husbandman 589774 589774 Pennythorne, Robert, of Swynflete, husbandman 0
4107144 2062848 2062848 defendant Waighte Francis yeoman 589774 589774 Waighte, Francis, of Swynflete, yeoman 0
4107145 2062849 2062849 plaintiff Pennythorne Robert husbandman 589774 589774 Pennythorne, Robert, of Swynflete, husbandman 0
4107146 2062849 2062849 defendant Wayte Richard yeoman 589774 589774 Wayte, Richard, of Swynflete, yeoman 0
4167700 2084193 2084193 defendant Wayte Richard yeoman 589774 589774 Wayte, Richard, of Swynflete, yeoman 5
4309415 2133452 2133452 defendant Gunbye Simon yeoman 589774 589774 Gunbye, Simon, of Swynflete, yeoman 2
4319179 2136822 2136822 defendant Arlushe Richard yeoman 589774 589774 Arlushe, Richard, of Swynflete, yeoman 1
4472260 2191994 2191994 defendant Danet William mariner 589774 589774 Danet, William, of Swynflete, mariner 0
4499191 2200394 2200394 plaintiff Grynder John   589774 589774 Grynder, John, of Swynflete 0
4500433 2200755 2200755 defendant Pogge Roger   589774 589774 Pogge, Roger, of Swynflete, 0
4500439 2200758 2200758 defendant Pogge Roger   589774 589774 Pogge, Roger, of Swynflete 0
4503586 2201699 2201699 defendant Smyth John   589774 589774 Smyth, John, of Swynflete 0
4515747 2205353 2205353 plaintiff Clerk Thomas   589774 589774 Clerk, Thomas, of Swynflete 0
4531671 2210168 2210168 defendant Pogg Walter   589774 589774 Pogg, Walter, of Swynflete 0
4543177 2213749 2213749 defendant Elmesale Richard   589774 589774 Elmesale, Richard, of Swynflete 0
4543179 2213750 2213750 defendant Elmesale Richard   589774 589774 Elmesale, Richard, of Swynflete 0
4543181 2213751 2213751 defendant Elmesale Richard   589774 589774 Elmesale, Richard, of Swynflete 0
4551757 2216495 2216495 plaintiff Elmesale Richard   589774 589774 Elmesale, Richard, of Swynflete 0
4551758 2216495 2216495 defendant Arnald Richard   589774 589774 Arnald, Richard, of Swynflete 0
4551764 2216498 2216498 plaintiff Elmeshall Richard   589774 589774 Elmeshall, Richard, of Swynflete 0
4551765 2216498 2216498 defendant Arnald John   589774 589774 Arnald, John, of Swynflete 0
4552391 2216701 2216701 defendant Clerk Thomas   589774 589774 Clerk, Thomas, of Swynflete 1
4560605 2219259 2219259 defendant Elmesale John   589774 589774 Elmesale, John, of Swynflete 0
4572128 2222834 2222834 plaintiff Arnald Richard   589774 589774 Arnald, Richard, of Swynflete 0
4572132 2222835 2222835 plaintiff Arnald Richard   589774 589774 Arnald, Richard, of Swynflete 0
4589607 2228118 2228118 defendant Arnald Richard, sen   589774 589774 Arnald, Richard, sen, of Swynflete 0
4589609 2228118 2228118 defendant Arnald William   589774 589774 Arnald, William, of Swynflete 2
4589610 2228118 2228118 defendant Smyth Richard   589774 589774 Smyth, Richard, of Swynflete 3
4591391 2228663 2228663 defendant Thorne Alan   589774 589774 Thorne, Alan, of Swynflete 0
4591392 2228663 2228663 defendant Hertley William   589774 589774 Hertley, William, of Swynflete 1
4591394 2228664 2228664 defendant Thorne Alan   589774 589774 Thorne, Alan, of Swynflete 0
4591395 2228664 2228664 defendant Hertley William   589774 589774 Hertley, William, of Swynflete 1
4629674 2240203 2240203 plaintiff Spendthorn Thomas   589774 589774 Spendthorn, Thomas, of Swynflete 0
4640765 2243401 2243401 defendant Elmesale John   589774 589774 Elmesale, John, of Swynflete 2
4642911 2244038 2244038 defendant Brouder John   589774 589774 Brouder, John, of Swynflete 0
4642914 2244038 2244038 defendant Haldenby Thomas   589774 589774 Haldenby, Thomas, of Swynflete 3
4642915 2244038 2244038 defendant Costard Thomas   589774 589774 Costard, Thomas, of Swynflete 4
4661519 2249434 2249434 defendant Herryson John yeoman 589774 589774 Herryson, John, of Swynflete, yeoman 1
4661523 2249435 2249435 defendant Haldenby Thomas husbandman 589774 589774 Haldenby, Thomas, of Swynflete, husbandman 1
4704635 2266829 2266829 plaintiff Jakson Thomas   589774 589774 Jakson, Thomas, of Swynflete 0
4708192 2267941 2267941 defendant Parler Richard husbandman 589774 589774 Parler, Richard, of Swynflete, husbandman 3
4729906 2274561 2274561 defendant Haldenby Thomas husbandman 589774 589774 Haldenby, Thomas, of Swynflete, husbandman 2
4729907 2274561 2274561 defendant Pyrle Richard husbandman 589774 589774 Pyrle, Richard, of Swynflete, husbandman 3
4729914 2274563 2274563 defendant Pyle Richard husbandman 589774 589774 Pyle, Richard, of Swynflete, husbandman 3
4746002 2279332 2279332 defendant West John husbandman 589774 589774 West, John, of Swynflete, husbandman 0
4749125 2280226 2280226 defendant Richardson Thomas husbandman 589774 589774 Richardson, Thomas, of Swynflete, husbandman 0
4776127 2288531 2288531 defendant Calverlay John husbandman 589774 589774 Calverlay, John, of Swynflete, husbandman 0
4785096 2291350 2291350 defendant Leven John husbandman 589774 589774 Leven, John, of Swynflete, husbandman 0
4815430 2300929 2300929 defendant Smyth John, senior husbandman 589774 589774 Smyth, John, senior, of Swynflete, husbandman 0
4815431 2300929 2300929 defendant Lenen or Leven John, junior husbandman 589774 589774 Lenen or Leven, John, junior, of Swynflete, husbandman 1
4815432 2300929 2300929 defendant Lenen or Leven Thomas husbandman 589774 589774 Lenen or Leven, Thomas, of Swynflete, husbandman 2
4852258 2312131 2312131 defendant Godfray John chapman 589774 589774 Godfray, John, of Swynflete, chapman 11
4853608 2312544 2312544 defendant Wryght Robert laborer 589774 589774 Wryght, Robert, of Swynflete, laborer 1
4877270 2319847 2319847 defendant Smyth John, senior husbandman 589774 589774 Smyth, John, senior, of Swynflete, husbandman 0
4877271 2319847 2319847 defendant Smyth John, junior husbandman 589774 589774 Smyth, John, junior, of Swynflete, husbandman 1
4877272 2319847 2319847 defendant Smyth John husbandman 589774 589774 Smyth, John, of Swynflete, husbandman 2
4877273 2319847 2319847 defendant Smyth William husbandman 589774 589774 Smyth, William, of Swynflete, husbandman 3
4877274 2319847 2319847 defendant Colthird Richard husbandman 589774 589774 Colthird, Richard, of Swynflete, husbandman 4
4890460 2323782 2323782 defendant Costerd Robert husbandman 589774 589774 Costerd, Robert, of Swynflete, husbandman 0
4933411 2336837 2336837 defendant Shephird Robert husbandman 589774 589774 Shephird, Robert, of Swynflete, husbandman 0
4933412 2336837 2336837 defendant Colthird William husbandman 589774 589774 Colthird, William, of Swynflete, husbandman 1
4933413 2336837 2336837 defendant Thomson John husbandman 589774 589774 Thomson, John, of Swynflete, husbandman 2
4933414 2336837 2336837 defendant Parrot William husbandman 589774 589774 Parrot, William, of Swynflete, husbandman 3
4939232 2338657 2338657 defendant Cowterd Richard husbandman 589774 589774 Cowterd, Richard, of Swynflete, husbandman 0
4939245 2338660 2338660 defendant of the Rawe William laborer 589774 589774 of the Rawe, William, of Swynflete, laborer 0
4975879 2349747 2349747 defendant Coltherd Richard husbandman 589774 589774 Coltherd, Richard, of Swynflete, husbandman 1
4975880 2349747 2349747 defendant Coltherd John husbandman 589774 589774 Coltherd, John, of Swynflete, husbandman 2
5069111 2377253 2377253 defendant Richardson Thomas husbandman 589774 589774 Richardson, Thomas, of Swynflete, husbandman 0
5110800 2389557 2389557 defendant Levyn or Lenyn or Leuyn Richard husbandman 589774 589774 Levyn or Lenyn or Leuyn, Richard, of Swynflete, husbandman 0
5228148 2423840 2423840 defendant Baron William yeoman 589774 589774 Baron, William, of Swynflete, yeoman 0
5228149 2423840 2423840 defendant Penythorn Robert yeoman 589774 589774 Penythorn, Robert, of Swynflete, yeoman 1
5242465 2428004 2428004 defendant Baron William yeoman 589774 589774 Baron, William, of Swynflete, yeoman 1
5242466 2428004 2428004 defendant Penythorn Robert yeoman 589774 589774 Penythorn, Robert, of Swynflete, yeoman 2
5247578 2429449 2429449 defendant Richardson Richard gent 589774 589774 Richardson, Richard, of Swynflete, gent 1
5277073 2438380 2438380 defendant Penythorn Robert yeoman 589774 589774 Penythorn, Robert, of Swynflete, yeoman 0
5277075 2438381 2438381 defendant Portyngton Robert yeoman 589774 589774 Portyngton, Robert, of Swynflete, yeoman 0
5288011 2441506 2441506 defendant Smyth John husbandman 589774 589774 Smyth, John, of Swynflete, husbandman 0
5288013 2441507 2441507 defendant Smyth John husbandman 589774 589774 Smyth, John, of Swynflete, husbandman 0
5333352 2455048 2455048 defendant Baron William, senior husbandman 589774 589774 Baron, William, senior, of Swynflete, husbandman 0
5348038 2459526 2459526 defendant Haldenby Robert, junior gent 589774 589774 Haldenby, Robert, junior, of Swynflete, gent 0
5356432 2462078 2462078 defendant Bretane William gent 589774 589774 Bretane, William, of Swynflete, gent 0
5387422 2471473 2471473 defendant Alkebarough Robert husbandman 589774 589774 Alkebarough, Robert, of Swynflete, husbandman 3
5399415 2474907 2474907 defendant Alkebarough Robert husbandman 589774 589774 Alkebarough, Robert, of Swynflete, husbandman 3
5399416 2474907 2474907 defendant Alkebarough Richard husbandman 589774 589774 Alkebarough, Richard, of Swynflete, husbandman 4
5399888 2475061 2475061 defendant Alkebarough Robert husbandman 589774 589774 Alkebarough, Robert, of Swynflete, husbandman 3
5412391 2478651 2478651 defendant Alkebarough Robert husbandman 589774 589774 Alkebarough, Robert, of Swynflete, husbandman 3

Next page

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